APPS.JL_JLMXFISR_XMLP_PKG dependencies on FA_DEPRN_SUMMARY

Line 591: FA_DEPRN_SUMMARY FDS

587: SELECT
588: FDS.ADJUSTED_COST,
589: FDS.PERIOD_COUNTER
590: FROM
591: FA_DEPRN_SUMMARY FDS
592: WHERE FDS.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
593: AND FDS.ASSET_ID = P_ASSET_ID
594: AND FDS.PERIOD_COUNTER between P_PERIOD_START
595: AND P_PERIOD_COUNTER;

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

756: DEPRN_RESERVE,
757: ADJUSTED_COST
758: INTO L_LAST_DEPRN_PERIOD_PREV_FY,L_ACC_DEPRN_PREV_FY,L_ADJUSTED_COST_PREV_FY
759: FROM
760: FA_DEPRN_SUMMARY
761: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
762: AND ASSET_ID = P_ASSET_ID
763: AND PERIOD_COUNTER = (
764: SELECT

Line 767: FA_DEPRN_SUMMARY FDS2

763: AND PERIOD_COUNTER = (
764: SELECT
765: MAX(FDS2.PERIOD_COUNTER)
766: FROM
767: FA_DEPRN_SUMMARY FDS2
768: WHERE FDS2.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
769: AND FDS2.ASSET_ID = P_ASSET_ID
770: AND FDS2.PERIOD_COUNTER <= P_PERIOD_START - 1 );
771: EXCEPTION

Line 840: FA_DEPRN_SUMMARY

836: SELECT
837: DEPRN_RESERVE / L_COST_BEGIN_YEAR * P_COST_RETIRED
838: INTO P_ACC_DEPRN_PREV_FY
839: FROM
840: FA_DEPRN_SUMMARY
841: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
842: AND ASSET_ID = P_ASSET_ID
843: AND PERIOD_COUNTER = L_LAST_DEPRN_PERIOD_PREV_FY;
844: 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 971: FA_DEPRN_SUMMARY

967: SELECT
968: DEPRN_RESERVE
969: INTO P_ACC_DEPRN_LIFE_TD
970: FROM
971: FA_DEPRN_SUMMARY
972: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
973: AND ASSET_ID = P_ASSET_ID
974: AND PERIOD_COUNTER = P_PERIOD_COUNTER;
975: 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';

Line 1088: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';

1084: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
1085: LP_FA_BOOKS := 'FA_BOOKS';
1086: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
1087: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
1088: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';
1089: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL';
1090: END IF;
1091: RETURN (TRUE);
1092: END AFTERPFORM;