[Home] [Help]
322: TO_CHAR(A.DATE_RETIRED
323: ,'MM')
324: INTO MON_RETIRED
325: FROM
326: FA_RETIREMENTS_MRC_V A
327: WHERE A.RETIREMENT_ID = RETIREMENT_ID_1;
328: EXCEPTION
329: WHEN OTHERS THEN
330: MON_RETIRED := 13;
335: TO_CHAR(A.DATE_RETIRED
336: ,'MM')
337: INTO MON_RETIRED
338: FROM
339: FA_RETIREMENTS A
340: WHERE A.RETIREMENT_ID = RETIREMENT_ID_1;
341: EXCEPTION
342: WHEN OTHERS THEN
343: MON_RETIRED := 13;
638: SELECT
639: COUNT(RET.RETIREMENT_ID)
640: INTO L_HAS_RETIREMENT
641: FROM
642: FA_RETIREMENTS_MRC_V RET,
643: FA_DEPRN_PERIODS_MRC_V FDP
644: WHERE RET.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
645: AND RET.STATUS <> 'DELETED'
646: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
716: SELECT
717: RET.COST_RETIRED
718: INTO L_COST_RETIRED
719: FROM
720: FA_RETIREMENTS_MRC_V RET,
721: FA_DEPRN_PERIODS_MRC_V FDP
722: WHERE RET.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
723: AND RET.STATUS <> 'DELETED'
724: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
782: SELECT
783: COUNT(RET.RETIREMENT_ID)
784: INTO L_HAS_RETIREMENT
785: FROM
786: FA_RETIREMENTS RET,
787: FA_DEPRN_PERIODS FDP
788: WHERE RET.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
789: AND RET.STATUS <> 'DELETED'
790: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
860: SELECT
861: RET.COST_RETIRED
862: INTO L_COST_RETIRED
863: FROM
864: FA_RETIREMENTS RET,
865: FA_DEPRN_PERIODS FDP
866: WHERE RET.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
867: AND RET.STATUS <> 'DELETED'
868: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
990: SELECT
991: DATE_RETIRED
992: INTO L_FA_RETIREMENT
993: FROM
994: FA_RETIREMENTS_MRC_V
995: WHERE RETIREMENT_ID = RETIREMENT_ID_1;
996: ELSE
997: SELECT
998: DATE_RETIRED
997: SELECT
998: DATE_RETIRED
999: INTO L_FA_RETIREMENT
1000: FROM
1001: FA_RETIREMENTS
1002: WHERE RETIREMENT_ID = RETIREMENT_ID_1;
1003: END IF;
1004: ELSE
1005: L_FA_RETIREMENT := NULL;