APPS.PAY_MX_YREND_ARCH dependencies on PER_PERIODS_OF_SERVICE

Line 1331: per_periods_of_service pps,

1327: FROM per_people_f ppf,
1328: per_assignments_f paf,
1329: per_assignments_f paf_all,
1330: pay_assignment_actions paa,
1331: per_periods_of_service pps,
1332: hr_organization_units hou,
1333: hr_organization_information hoi,
1334: hr_locations_all hl,
1335: pay_payroll_actions ppa

Line 1421: per_periods_of_service pps

1417: FROM per_people_f ppf,
1418: per_assignments_f paf,
1419: pay_assignment_actions paa,
1420: pay_payroll_actions ppa,
1421: per_periods_of_service pps
1422: WHERE paa.assignment_action_id = p_archive_action_id
1423: AND ppa.payroll_action_id = paa.payroll_action_id
1424: AND paf.assignment_id = paa.assignment_id
1425: AND ppf.person_id = paf.person_id

Line 1682: FROM per_periods_of_service pps

1678:
1679: CURSOR c_get_hire_date ( cp_person_id NUMBER
1680: ,cp_effective_date DATE ) IS
1681: SELECT MAX (pps.date_start)
1682: FROM per_periods_of_service pps
1683: WHERE pps.person_id = cp_person_id
1684: AND pps.date_start <= cp_effective_date;
1685:
1686: lv_ann_tax_calc_type VARCHAR2(240);