DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_ACUI_EXP_PKG dependencies on FA_BOOK_CONTROLS_SEC

Line 239: , fa_book_controls_sec fbc

235: , fb.book_type_code
236: FROM
237: fa_additions_v faav
238: , fa_books fb
239: , fa_book_controls_sec fbc
240: , fa_distribution_history fdh
241: , fa_transaction_history_trx_v fthv
242: WHERE fb.date_ineffective IS NULL
243: AND fb.transaction_header_id_out IS NULL

Line 313: , fa_book_controls_sec fbc

309: fa_distribution_history fdh
310: , per_people_f ppf
311: , per_assignments_f paf
312: , per_periods_of_service pos
313: , fa_book_controls_sec fbc
314: WHERE fbc.book_type_code = pv_book_type_code
315: AND fdh.book_type_code = fbc.distribution_source_book
316: AND fdh.asset_id = pv_asset_id
317: AND (ld_end_date BETWEEN paf.effective_start_date

Line 378: , fa_book_controls_sec fbc

374: SUM(fdh.units_assigned)
375: , fdh.assigned_to
376: FROM
377: fa_distribution_history fdh
378: , fa_book_controls_sec fbc
379: WHERE fbc.book_type_code = pv_book_type_code
380: AND fdh.book_type_code = fbc.distribution_source_book
381: AND fdh.asset_id = pv_asset_id
382: -- Check legal entity