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