DBA Data[Home] [Help]

APPS.JA_CN_FA_ACUI_EXPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 323: per_assignments_f paf,

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