APPS.JL_JLMXFISR_XMLP_PKG dependencies on FA_ADJUSTMENTS

Line 917: FA_ADJUSTMENTS_MRC_V FAD

913: SELECT
914: SUM(FAD.ADJUSTMENT_AMOUNT)
915: INTO P_ACC_DEPRN_LIFE_TD
916: FROM
917: FA_ADJUSTMENTS_MRC_V FAD
918: WHERE FAD.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
919: AND FAD.ASSET_ID = P_ASSET_ID
920: AND FAD.SOURCE_TYPE_CODE = 'RETIREMENT'
921: AND FAD.ADJUSTMENT_TYPE = 'RESERVE'

Line 953: FA_ADJUSTMENTS FAD

949: SELECT
950: SUM(FAD.ADJUSTMENT_AMOUNT)
951: INTO P_ACC_DEPRN_LIFE_TD
952: FROM
953: FA_ADJUSTMENTS FAD
954: WHERE FAD.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
955: AND FAD.ASSET_ID = P_ASSET_ID
956: AND FAD.SOURCE_TYPE_CODE = 'RETIREMENT'
957: AND FAD.ADJUSTMENT_TYPE = 'RESERVE'

Line 1079: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';

1075: END IF;
1076: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
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

Line 1086: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';

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';
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;