APPS.JL_JLMXFGLR_XMLP_PKG dependencies on FA_DEPRN_SUMMARY_MRC_V

Line 242: FA_DEPRN_SUMMARY_MRC_V

238: DEPRN_RESERVE,
239: ADJUSTED_COST
240: INTO L_LAST_DEPRN_PERIOD_PREV_FY,L_ACC_DEPRN_PREV_FY,L_ADJUSTED_COST_PREV_FY
241: FROM
242: FA_DEPRN_SUMMARY_MRC_V
243: WHERE BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
244: AND ASSET_ID = T_ASSET_ID
245: AND PERIOD_COUNTER = (
246: SELECT

Line 249: FA_DEPRN_SUMMARY_MRC_V FDS2

245: AND PERIOD_COUNTER = (
246: SELECT
247: MAX(FDS2.PERIOD_COUNTER)
248: FROM
249: FA_DEPRN_SUMMARY_MRC_V FDS2
250: WHERE FDS2.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
251: AND FDS2.ASSET_ID = T_ASSET_ID
252: AND FDS2.PERIOD_COUNTER <= T_PERIOD_START - 1 );
253: EXCEPTION

Line 330: FA_DEPRN_SUMMARY_MRC_V

326: SELECT
327: DEPRN_RESERVE / L_COST_BEGIN_YEAR * L_COST_RETIRED
328: INTO T_ACC_DEPRN_PREV_FY
329: FROM
330: FA_DEPRN_SUMMARY_MRC_V
331: WHERE BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
332: AND ASSET_ID = T_ASSET_ID
333: AND PERIOD_COUNTER = L_LAST_DEPRN_PERIOD_PREV_FY;
334: EXCEPTION

Line 594: FA_DEPRN_SUMMARY_MRC_V

590: SELECT
591: DEPRN_RESERVE
592: INTO T_ACC_DEPRN_LIFE_TD
593: FROM
594: FA_DEPRN_SUMMARY_MRC_V
595: WHERE BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
596: AND ASSET_ID = T_ASSET_ID
597: AND PERIOD_COUNTER = T_PERIOD_COUNTER;
598: EXCEPTION

Line 961: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';

957: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
958: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
959: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
960: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
961: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
962: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
963: ELSE
964: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
965: LP_FA_BOOKS := 'FA_BOOKS';