DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_PERIODS_OF_SERVICE

Line 799: FROM per_all_assignments_f paf, per_all_people_f ppf, per_periods_of_service

795: paf.job_id,
796: paf.organization_id, paf.supervisor_id, paf.effective_start_date,
797: pps.date_start empl_start_date,
798: ppf.effective_end_date empl_end_date, ppf.person_id
799: FROM per_all_assignments_f paf, per_all_people_f ppf, per_periods_of_service
800: pps
801: WHERE paf.assignment_id = p_assignment_id
802: and trunc(sysdate) between paf.effective_start_date and
803: paf.effective_end_date