APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PER_ADDRESSES

Line 570: FROM per_addresses pas

566: CURSOR csr_province_code(c_assignment_id NUMBER
567: ,c_business_group_id NUMBER
568: ,c_reporting_date DATE) IS
569: SELECT region_2
570: FROM per_addresses pas
571: ,per_all_people_f pap
572: ,per_all_assignments_f paa
573: WHERE paa.person_id = pap.person_id
574: AND pas.person_id = pap.person_id

Line 599: l_province_code per_addresses.region_2%TYPE;

595: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
596: l_payroll_id hr_assignment_sets.payroll_id%TYPE;
597: l_incl_excl hr_assignment_set_amendments.include_or_exclude%TYPE;
598: l_legal_employer hr_all_organization_units.organization_id%TYPE;
599: l_province_code per_addresses.region_2%TYPE;
600: l_ss_number pay_element_entry_values_f.screen_entry_value%TYPE;
601: --
602: BEGIN
603: --