APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 2408: FROM per_periods_of_service ppos,

2404: CURSOR c_get_pos_leaving_reason ( cp_assignment_id IN NUMBER
2405: ,cp_effective_date IN DATE ) IS
2406: SELECT pds_information1
2407: ,actual_termination_date
2408: FROM per_periods_of_service ppos,
2409: per_all_assignments_f paf
2410: WHERE paf.assignment_id = cp_assignment_id
2411: AND paf.person_id = ppos.person_id
2412: AND cp_effective_date BETWEEN paf.effective_start_date