DBA Data[Home] [Help]

APPS.PAY_IE_CESS_REPORT dependencies on PER_ALL_PEOPLE_F

Line 370: per_all_people_f ppf,

366: ppf.national_identifier PPSN,
367: paf.assignment_number works_no,
368: pps.date_start hire_date
369: from per_assignments_f paf,
370: per_all_people_f ppf,
371: per_periods_of_service pps
372: where paf.person_id = ppf.person_id
373: and paf.assignment_id = cp_assignment_id
374: and cp_curr_eff_date between paf.effective_start_date