APPS.PAY_MX_YREND_ARCH dependencies on PER_PERIODS_OF_SERVICE

Line 1569: per_periods_of_service pps,

1565: FROM per_people_f ppf,
1566: per_assignments_f paf,
1567: per_assignments_f paf_all,
1568: pay_assignment_actions paa,
1569: per_periods_of_service pps,
1570: hr_organization_units hou,
1571: hr_organization_information hoi,
1572: hr_locations_all hl,
1573: pay_payroll_actions ppa

Line 1664: per_periods_of_service pps

1660: FROM per_people_f ppf,
1661: per_assignments_f paf,
1662: pay_assignment_actions paa,
1663: pay_payroll_actions ppa,
1664: per_periods_of_service pps
1665: WHERE paa.assignment_action_id = p_archive_action_id
1666: AND ppa.payroll_action_id = paa.payroll_action_id
1667: AND paf.assignment_id = paa.assignment_id
1668: AND ppf.person_id = paf.person_id

Line 1928: FROM per_periods_of_service pps

1924:
1925: CURSOR c_get_hire_date ( cp_person_id NUMBER
1926: ,cp_effective_date DATE ) IS
1927: SELECT MAX (pps.date_start)
1928: FROM per_periods_of_service pps
1929: WHERE pps.person_id = cp_person_id
1930: AND pps.date_start <= cp_effective_date;
1931:
1932: /*bug 11715919 */

Line 1936: FROM per_periods_of_service

1932: /*bug 11715919 */
1933: CURSOR c_get_max_arch_end_date ( cp_person_id NUMBER) IS
1934: SELECT NVL(max(actual_termination_date),
1935: fnd_date.canonical_to_date(g_fiscal_year || '/12/31'))
1936: FROM per_periods_of_service
1937: WHERE person_id = cp_person_id
1938: AND actual_termination_date
1939: BETWEEN fnd_date.canonical_to_date(g_fiscal_year || '/01/01')
1940: AND fnd_date.canonical_to_date(g_fiscal_year || '/12/31');