DBA Data[Home] [Help]

APPS.JA_CN_FA_ACUI_EXPORT_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 324: per_periods_of_service pos,

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
326: WHERE fbc.book_type_code = pv_book_type_code
327: AND fdh.book_type_code = fbc.distribution_source_book
328: AND fdh.asset_id = pv_asset_id