APPS.JL_JLMXFIMP_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 243: FA_DEPRN_PERIODS_MRC_V

239: SELECT
240: PERIOD_NUM
241: INTO L_RETIREMENT_MONTH
242: FROM
243: FA_DEPRN_PERIODS_MRC_V
244: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
245: AND PERIOD_COUNTER = PERIOD_COUNTER_FULLY_RESERVED;
246: END;
247: ELSE

Line 253: FA_DEPRN_PERIODS

249: SELECT
250: PERIOD_NUM
251: INTO L_RETIREMENT_MONTH
252: FROM
253: FA_DEPRN_PERIODS
254: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
255: AND PERIOD_COUNTER = PERIOD_COUNTER_FULLY_RESERVED;
256: END;
257: END IF;

Line 307: FA_DEPRN_PERIODS_MRC_V

303: MIN(PERIOD_COUNTER),
304: MAX(PERIOD_COUNTER)
305: INTO V_MIN_PERIOD_COUNTER,V_MAX_PERIOD_COUNTER
306: FROM
307: FA_DEPRN_PERIODS_MRC_V
308: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
309: AND FISCAL_YEAR = P_CURR_FY;
310: EXCEPTION
311: WHEN NO_DATA_FOUND THEN

Line 342: FA_DEPRN_PERIODS

338: MIN(PERIOD_COUNTER),
339: MAX(PERIOD_COUNTER)
340: INTO V_MIN_PERIOD_COUNTER,V_MAX_PERIOD_COUNTER
341: FROM
342: FA_DEPRN_PERIODS
343: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
344: AND FISCAL_YEAR = P_CURR_FY;
345: EXCEPTION
346: WHEN NO_DATA_FOUND THEN

Line 648: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';

644: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
645: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
646: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
647: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
648: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
649: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
650: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
651: ELSE
652: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';

Line 655: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';

651: ELSE
652: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
653: LP_FA_BOOKS := 'FA_BOOKS';
654: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
655: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
656: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAL';
657: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';
658: END IF;
659: RETURN (TRUE);