APPS.JA_CN_FA_ACUI_EXPORT_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 260: fa_distribution_history fdh,

256: fb.book_type_code --- corporate book code, the asset in tax book cannot be assigned.
257: FROM fa_additions_v faav,
258: fa_books fb,
259: fa_book_controls_sec fbc,
260: fa_distribution_history fdh,
261: fa_transaction_history_trx_v fthv
262: WHERE fb.date_ineffective IS NULL
263: AND fb.transaction_header_id_out IS NULL
264: AND faav.asset_id = fb.asset_id

Line 321: FROM fa_distribution_history fdh,

317:
318: CURSOR fa_assignment_cur(pv_book_type_code VARCHAR2,
319: pv_asset_id VARCHAR2) IS
320: SELECT SUM(fdh.units_assigned), paf.organization_id
321: FROM fa_distribution_history fdh,
322: per_people_f ppf,
323: per_assignments_f paf,
324: per_periods_of_service pos,
325: fa_book_controls_sec fbc

Line 375: FROM fa_distribution_history fdh, fa_book_controls_sec fbc

371: AND paf.primary_flag = 'Y'
372: GROUP BY paf.organization_id
373: UNION
374: SELECT SUM(fdh.units_assigned), fdh.assigned_to
375: FROM fa_distribution_history fdh, fa_book_controls_sec fbc
376: WHERE fbc.book_type_code = pv_book_type_code
377: AND fdh.book_type_code = fbc.distribution_source_book
378: AND fdh.asset_id = pv_asset_id
379: -- Check legal entity