APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 278: FROM hr_all_organization_units hou

274: ,hoi.org_information4 Employer_Type
275: ,hoi.org_information1 Registered_Name
276: ,hoi.organization_id Legal_emp_org_id
277: /* Reserved, Seg. Hdr, Start and End date are defaulted */
278: FROM hr_all_organization_units hou
279: ,hr_organization_information hoi
280: ,hr_locations_all hloc
281: WHERE hou.business_group_id = c_business_group_id
282: AND hoi.organization_id = hou.organization_id

Line 598: l_legal_employer hr_all_organization_units.organization_id%TYPE;

594: l_retirement_age_reduction pay_element_entry_values_f.screen_entry_value%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