DBA Data[Home] [Help]

APPS.PAY_HK_AVG_PAY dependencies on PER_ASSIGNMENTS_F

Line 199: per_assignments_f paf

195: IS
196: SELECT pps.date_start
197: FROM per_periods_of_service pps,
198: per_people_f ppf,
199: per_assignments_f paf
200: WHERE paf.person_id = ppf.person_id
201: AND pps.person_id = paf.person_id
202: AND paf.assignment_id = p_assignment_id
203: AND paf.period_of_service_id = pps.period_of_service_id;