DBA Data[Home] [Help]

APPS.JL_JLZZFIJR_XMLP_PKG dependencies on FA_ADJUSTMENTS

Line 34: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';

30: ,'Curr' || CP_PARAM_CURRENCY || 'END')*/NULL;
31: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
32: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
33: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
34: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
35: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
36: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
37: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
38: ELSE

Line 41: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';

37: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
38: ELSE
39: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
40: LP_FA_BOOKS := 'FA_BOOKS';
41: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
42: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
43: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';
44: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL';
45: END IF;

Line 177: FA_ADJUSTMENTS_MRC_V

173: ,-ADJUSTMENT_AMOUNT)))
174: ,0)
175: INTO L_AMT
176: FROM
177: FA_ADJUSTMENTS_MRC_V
178: WHERE BOOK_TYPE_CODE = P_BOOK
179: AND SOURCE_TYPE_CODE = 'REVALUATION'
180: AND ADJUSTMENT_TYPE = 'RESERVE'
181: AND ASSET_ID = ASSET_ID

Line 193: FA_ADJUSTMENTS

189: ,-ADJUSTMENT_AMOUNT)))
190: ,0)
191: INTO L_AMT
192: FROM
193: FA_ADJUSTMENTS
194: WHERE BOOK_TYPE_CODE = P_BOOK
195: AND SOURCE_TYPE_CODE = 'REVALUATION'
196: AND ADJUSTMENT_TYPE = 'RESERVE'
197: AND ASSET_ID = ASSET_ID

Line 217: FA_ADJUSTMENTS_MRC_V

213: ,-ADJUSTMENT_AMOUNT)))
214: ,0)
215: INTO L_AMT
216: FROM
217: FA_ADJUSTMENTS_MRC_V
218: WHERE BOOK_TYPE_CODE = P_BOOK
219: AND SOURCE_TYPE_CODE = 'REVALUATION'
220: AND ADJUSTMENT_TYPE = 'EXPENSE'
221: AND ASSET_ID = ASSET_ID

Line 233: FA_ADJUSTMENTS

229: ,-ADJUSTMENT_AMOUNT)))
230: ,0)
231: INTO L_AMT
232: FROM
233: FA_ADJUSTMENTS
234: WHERE BOOK_TYPE_CODE = P_BOOK
235: AND SOURCE_TYPE_CODE = 'REVALUATION'
236: AND ADJUSTMENT_TYPE = 'EXPENSE'
237: AND ASSET_ID = ASSET_ID