APPS.JL_JLMXFGLR_XMLP_PKG dependencies on FA_RETIREMENTS

Line 269: FA_RETIREMENTS_MRC_V RET,

265: SELECT
266: COUNT(RET.RETIREMENT_ID)
267: INTO L_HAS_RETIREMENT
268: FROM
269: FA_RETIREMENTS_MRC_V RET,
270: FA_DEPRN_PERIODS_MRC_V FDP
271: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
272: AND RET.STATUS <> 'DELETED'
273: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE

Line 354: FA_RETIREMENTS_MRC_V RET,

350: SELECT
351: RET.COST_RETIRED
352: INTO L_COST_RETIRED
353: FROM
354: FA_RETIREMENTS_MRC_V RET,
355: FA_DEPRN_PERIODS_MRC_V FDP
356: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
357: AND RET.STATUS <> 'DELETED'
358: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE

Line 421: FA_RETIREMENTS RET,

417: SELECT
418: COUNT(RET.RETIREMENT_ID)
419: INTO L_HAS_RETIREMENT
420: FROM
421: FA_RETIREMENTS RET,
422: FA_DEPRN_PERIODS FDP
423: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
424: AND RET.STATUS <> 'DELETED'
425: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE

Line 506: FA_RETIREMENTS RET,

502: SELECT
503: RET.COST_RETIRED
504: INTO L_COST_RETIRED
505: FROM
506: FA_RETIREMENTS RET,
507: FA_DEPRN_PERIODS FDP
508: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
509: AND RET.STATUS <> 'DELETED'
510: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE