APPS.JL_JLMXFISR_XMLP_PKG dependencies on FA_RETIREMENTS_MRC_V

Line 326: FA_RETIREMENTS_MRC_V A

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;

Line 642: FA_RETIREMENTS_MRC_V RET,

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

Line 720: FA_RETIREMENTS_MRC_V RET,

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

Line 994: FA_RETIREMENTS_MRC_V

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