APPS.JL_JLMXFGLR_XMLP_PKG dependencies on FA_DEPRN_SUMMARY

Line 217: FA_DEPRN_SUMMARY FDS

213: SELECT
214: FDS.ADJUSTED_COST,
215: FDS.PERIOD_COUNTER
216: FROM
217: FA_DEPRN_SUMMARY FDS
218: WHERE FDS.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
219: AND FDS.ASSET_ID = T_ASSET_ID
220: AND FDS.PERIOD_COUNTER between T_PERIOD_START
221: AND T_PERIOD_COUNTER;

Line 227: FA_DEPRN_SUMMARY FDS

223: SELECT
224: FDS.ADJUSTED_COST,
225: FDS.PERIOD_COUNTER
226: FROM
227: FA_DEPRN_SUMMARY FDS
228: WHERE FDS.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
229: AND FDS.ASSET_ID = T_ASSET_ID
230: AND FDS.PERIOD_COUNTER between T_PERIOD_START
231: AND T_PERIOD_COUNTER;

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 394: FA_DEPRN_SUMMARY

390: DEPRN_RESERVE,
391: ADJUSTED_COST
392: INTO L_LAST_DEPRN_PERIOD_PREV_FY,L_ACC_DEPRN_PREV_FY,L_ADJUSTED_COST_PREV_FY
393: FROM
394: FA_DEPRN_SUMMARY
395: WHERE BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
396: AND ASSET_ID = T_ASSET_ID
397: AND PERIOD_COUNTER = (
398: SELECT

Line 401: FA_DEPRN_SUMMARY FDS2

397: AND PERIOD_COUNTER = (
398: SELECT
399: MAX(FDS2.PERIOD_COUNTER)
400: FROM
401: FA_DEPRN_SUMMARY FDS2
402: WHERE FDS2.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
403: AND FDS2.ASSET_ID = T_ASSET_ID
404: AND FDS2.PERIOD_COUNTER <= T_PERIOD_START - 1 );
405: EXCEPTION

Line 482: FA_DEPRN_SUMMARY

478: SELECT
479: DEPRN_RESERVE / L_COST_BEGIN_YEAR * L_COST_RETIRED
480: INTO T_ACC_DEPRN_PREV_FY
481: FROM
482: FA_DEPRN_SUMMARY
483: WHERE BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
484: AND ASSET_ID = T_ASSET_ID
485: AND PERIOD_COUNTER = L_LAST_DEPRN_PERIOD_PREV_FY;
486: 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 630: FA_DEPRN_SUMMARY

626: SELECT
627: DEPRN_RESERVE
628: INTO T_ACC_DEPRN_LIFE_TD
629: FROM
630: FA_DEPRN_SUMMARY
631: WHERE BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
632: AND ASSET_ID = T_ASSET_ID
633: AND PERIOD_COUNTER = T_PERIOD_COUNTER;
634: 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';

Line 968: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';

964: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
965: LP_FA_BOOKS := 'FA_BOOKS';
966: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
967: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
968: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';
969: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL';
970: END IF;
971: RETURN (TRUE);
972: END AFTERPFORM;