DBA Data[Home] [Help]

APPS.JL_ZZ_FA_CALC_ADJUSTMENT_PKG dependencies on FA_DEPRN_PERIODS

Line 101: FROM fa_deprn_periods dpc,

97:
98: IF (p_mode = 'CC') THEN
99: SELECT bkc.cost
100: INTO x_cost
101: FROM fa_deprn_periods dpc,
102: fa_book_controls bcc,
103: fa_books bkc
104: WHERE bcc.book_type_code = p_book_type_code
105: AND dpc.book_type_code = bcc.book_type_code

Line 119: FROM fa_deprn_periods dpc,

115:
116: IF (p_mode = 'CO') THEN
117: SELECT bkc.cost
118: INTO x_cost
119: FROM fa_deprn_periods dpc,
120: fa_book_controls bcc,
121: fa_books bkc
122: WHERE bcc.book_type_code = p_book_type_code
123: AND dpc.book_type_code = bcc.book_type_code

Line 136: FROM fa_deprn_periods dpc,

132:
133: IF (p_mode = 'OO') THEN
134: SELECT bkc.cost
135: INTO x_cost
136: FROM fa_deprn_periods dpc,
137: fa_book_controls bcc,
138: fa_books bkc
139: WHERE bcc.book_type_code = p_book_type_code
140: AND dpc.book_type_code = bcc.book_type_code

Line 192: fa_deprn_periods dpc,

188: IF (p_mode = 'CC') THEN
189: SELECT dsc.deprn_reserve
190: INTO x_deprn_reserve
191: FROM fa_deprn_summary dsc,
192: fa_deprn_periods dpc,
193: fa_book_controls bcc,
194: fa_books bkc
195: WHERE bcc.book_type_code = p_book_type_code
196: AND dpc.book_type_code = bcc.book_type_code

Line 214: fa_deprn_periods dpc,

210: IF (p_mode = 'CO') THEN
211: SELECT dsc.deprn_reserve
212: INTO x_deprn_reserve
213: FROM fa_deprn_summary dsc,
214: fa_deprn_periods dpc,
215: fa_book_controls bcc,
216: fa_books bkc
217: WHERE bcc.book_type_code = p_book_type_code
218: AND dpc.book_type_code = bcc.book_type_code

Line 235: fa_deprn_periods dpc,

231: IF (p_mode = 'OO') THEN
232: SELECT dsc.deprn_reserve - jl_zz_fa_calc_adjustment_pkg.calc_adjustments (bcc.book_type_code, dpc.period_counter, p_asset_id, 'RESERVE', 'NET' )
233: INTO x_deprn_reserve
234: FROM fa_deprn_summary dsc,
235: fa_deprn_periods dpc,
236: fa_book_controls bcc,
237: fa_books bkc
238: WHERE bcc.book_type_code = p_book_type_code
239: AND dpc.book_type_code = bcc.book_type_code

Line 294: fa_deprn_periods dpc,

290: IF (p_mode = 'CC') THEN
291: SELECT dsc.ytd_deprn
292: INTO x_ytd_deprn
293: FROM fa_deprn_summary dsc,
294: fa_deprn_periods dpc,
295: fa_book_controls bcc,
296: fa_books bkc
297: WHERE bcc.book_type_code = p_book_type_code
298: AND dpc.book_type_code = bcc.book_type_code

Line 316: fa_deprn_periods dpc,

312: IF (p_mode = 'CO') THEN
313: SELECT dsc.ytd_deprn
314: INTO x_ytd_deprn
315: FROM fa_deprn_summary dsc,
316: fa_deprn_periods dpc,
317: fa_book_controls bcc,
318: fa_books bkc
319: WHERE bcc.book_type_code = p_book_type_code
320: AND dpc.book_type_code = bcc.book_type_code

Line 337: fa_deprn_periods dpc,

333: IF (p_mode = 'OO') THEN
334: SELECT dsc.ytd_deprn + jl_zz_fa_calc_adjustment_pkg.calc_adjustments (bcc.book_type_code, dpc.period_counter, p_asset_id, 'EXPENSE', 'NET' )
335: INTO x_ytd_deprn
336: FROM fa_deprn_summary dsc,
337: fa_deprn_periods dpc,
338: fa_book_controls bcc,
339: fa_books bkc
340: WHERE bcc.book_type_code = p_book_type_code
341: AND dpc.book_type_code = bcc.book_type_code