APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 2532: FROM per_periods_of_service ppos,

2528: CURSOR c_get_pos_leaving_reason ( cp_assignment_id IN NUMBER
2529: ,cp_effective_date IN DATE ) IS
2530: SELECT pds_information1
2531: ,actual_termination_date
2532: FROM per_periods_of_service ppos,
2533: per_all_assignments_f paf
2534: WHERE paf.assignment_id = cp_assignment_id
2535: AND paf.person_id = ppos.person_id
2536: AND cp_effective_date BETWEEN paf.effective_start_date