APPS.JL_JLMXFISR_XMLP_PKG dependencies on FA_DEPRN_SUMMARY_MRC_V

Line 601: FA_DEPRN_SUMMARY_MRC_V FDS

597: SELECT
598: FDS.ADJUSTED_COST,
599: FDS.PERIOD_COUNTER
600: FROM
601: FA_DEPRN_SUMMARY_MRC_V FDS
602: WHERE FDS.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
603: AND FDS.ASSET_ID = P_ASSET_ID
604: AND FDS.PERIOD_COUNTER between P_PERIOD_START
605: AND P_PERIOD_COUNTER;

Line 616: FA_DEPRN_SUMMARY_MRC_V

612: DEPRN_RESERVE,
613: ADJUSTED_COST
614: INTO L_LAST_DEPRN_PERIOD_PREV_FY,L_ACC_DEPRN_PREV_FY,L_ADJUSTED_COST_PREV_FY
615: FROM
616: FA_DEPRN_SUMMARY_MRC_V
617: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
618: AND ASSET_ID = P_ASSET_ID
619: AND PERIOD_COUNTER = (
620: SELECT

Line 623: FA_DEPRN_SUMMARY_MRC_V FDS2

619: AND PERIOD_COUNTER = (
620: SELECT
621: MAX(FDS2.PERIOD_COUNTER)
622: FROM
623: FA_DEPRN_SUMMARY_MRC_V FDS2
624: WHERE FDS2.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
625: AND FDS2.ASSET_ID = P_ASSET_ID
626: AND FDS2.PERIOD_COUNTER <= P_PERIOD_START - 1 );
627: EXCEPTION

Line 696: FA_DEPRN_SUMMARY_MRC_V

692: SELECT
693: DEPRN_RESERVE / L_COST_BEGIN_YEAR * P_COST_RETIRED
694: INTO P_ACC_DEPRN_PREV_FY
695: FROM
696: FA_DEPRN_SUMMARY_MRC_V
697: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
698: AND ASSET_ID = P_ASSET_ID
699: AND PERIOD_COUNTER = L_LAST_DEPRN_PERIOD_PREV_FY;
700: EXCEPTION

Line 935: FA_DEPRN_SUMMARY_MRC_V

931: SELECT
932: DEPRN_RESERVE
933: INTO P_ACC_DEPRN_LIFE_TD
934: FROM
935: FA_DEPRN_SUMMARY_MRC_V
936: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
937: AND ASSET_ID = P_ASSET_ID
938: AND PERIOD_COUNTER = P_PERIOD_COUNTER;
939: EXCEPTION

Line 1081: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';

1077: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
1078: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
1079: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
1080: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
1081: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
1082: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
1083: ELSE
1084: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
1085: LP_FA_BOOKS := 'FA_BOOKS';