UNIX for Advanced & Expert Users

 ${SQLPLUS_SETTINGS}
        select c.CYCLE_CODE ||'|'|| NEXT_CYCLE_INST ||'|'||  CYCLE_YEAR ||'|'|| to_char(trunc(CYCLE_CLOSE_DATE +1),'DD-MON-YY
YY')||'|'|| to_char(ADD_MONTHS(CYCLE_CLOSE_DATE,1),'DD-MON-YYYY') ||'|'|| CYCLE_MONTH  FROM PM1_CYCLE_STATE C, RPR1_CYCLE_PAR
TITION_REL CPR WHERE C.CYCLE_CODE = CPR.CYCLE_CODE AND C.PARTITION_ID = CPR.PARTITION_ID AND CPR.PARTITION_ID = 15 AND TRUNC
(C.CYCLE_CLOSE_DATE) >= (SELECT MAX (LOGICAL_DATE) FROM LOGICAL_DATE WHERE LOGICAL_DATE_TYPE = 'B' AND EXPIRATION_DATE IS NUL
L) order by c.cycle_code,c.cycle_year,c.cycle_month;

export PREV_CYCLE_NO=$CYCLE_NO
        export NXT_CYCLE_MONTH=`echo $CYCLE|cut -d'|' -f2`
        export NXT_CYCLE_YEAR=`echo $CYCLE|cut -d'|' -f3`

        export NXT_CYCLE_START_DATE=`echo $CYCLE|cut -d'|' -f4`
        export NXT_CYCLE_CLOSE_DATE=`echo $CYCLE|cut -d'|' -f5`
        export PREV_CYCLE_INST=`echo $CYCLE|cut -d'|' -f6`

        mon=`echo $NXT_CYCLE_CLOSE_DATE|cut -d'-' -f2`
        year=`echo $NXT_CYCLE_CLOSE_DATE|cut -d'-' -f3`
        export NXT_CYCLE_CLOSE_DATE='28-'$mon'-'$year
        echo $NXT_CYCLE_CLOSE_DATE

export NXT_CYCLE_CLOSE_DATE=$day-$mon-$year
echo $NXT_CYCLE_CLOSE_DATE

select c.CYCLE_CODE ||'|'|| NEXT_CYCLE_INST ||'|'|| CYCLE_YEAR ||'|'|| to_char(trunc(CYCLE_CLOSE_DATE +1),'DD-MON-YYYY')||'|'||
 to_char(ADD_MONTHS(CYCLE_CLOSE_DATE,1),'DD-MON-YYYY') ||'|'|| CYCLE_MONTH ||'|'|| d.CYCLE_CLOSE_DAY FROM PM1_CYCLE_STATE C, 
RPR1_CYCLE_PARTITION_REL CPR,CYCLE_DEFINITION D WHERE C.CYCLE_CODE = CPR.CYCLE_CODE AND C.PARTITION_ID
 = CPR.PARTITION_ID AND CPR.PARTITION_ID = 15 and C.CYCLE_CODE=D.CYCLE_CODE AND TRUNC
(C.CYCLE_CLOSE_DATE) >= (SELECT MAX (LOGICAL_DATE) FROM LOGICAL_DATE WHERE LOGICAL_DATE_TYPE = 'B' AND EXPIRATION_DATE IS
 NULL) order by c.cycle_code,c.cycle_year,c.cycle_month;