APPS.JL_ZZ_FA_CALC_ADJUSTMENT_PKG dependencies on FA_BOOKS

Line 103: fa_books bkc

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
106: AND dpc.period_counter <= bcc.last_period_counter
107: AND dpc.period_counter = p_period_counter

Line 121: fa_books bkc

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
124: AND dpc.period_counter = bcc.last_period_counter
125: AND bkc.asset_id = p_asset_id

Line 138: fa_books bkc

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
141: AND dpc.period_counter = bcc.last_period_counter + 1
142: AND bkc.asset_id = p_asset_id

Line 194: fa_books bkc

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
197: AND dpc.period_counter <= bcc.last_period_counter
198: AND dpc.period_counter = p_period_counter

Line 216: fa_books bkc

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
219: AND dpc.period_counter = bcc.last_period_counter
220: AND bkc.asset_id = p_asset_id

Line 237: fa_books bkc

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
240: AND dpc.period_counter = bcc.last_period_counter + 1
241: AND bkc.asset_id = p_asset_id

Line 296: fa_books bkc

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
299: AND dpc.period_counter <= bcc.last_period_counter
300: AND dpc.period_counter = p_period_counter

Line 318: fa_books bkc

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
321: AND dpc.period_counter = bcc.last_period_counter
322: AND bkc.asset_id = p_asset_id

Line 339: fa_books bkc

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
342: AND dpc.period_counter = bcc.last_period_counter + 1
343: AND bkc.asset_id = p_asset_id