DBA Data[Home] [Help]

APPS.JL_JLMXFGLR_XMLP_PKG dependencies on FA_RETIREMENTS_MRC_V

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