DBA Data[Home] [Help]

APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PER_PERIODS_OF_SERVICE

Line 484: FROM per_periods_of_service pps

480: --
481: CURSOR csr_hire_date
482: IS
483: SELECT date_start
484: FROM per_periods_of_service pps
485: , per_assignments_f paf
486: WHERE pps.period_of_service_id = paf.period_of_service_id
487: AND pps.person_id = paf.person_id
488: AND paf.assignment_id = p_assignment_id;