APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on HR_LOCATIONS

Line 2676: from hr_locations

2672:
2673: cursor csr_location_code(p_location_id number)
2674: is
2675: select location_code
2676: from hr_locations
2677: where location_id = p_location_id;
2678:
2679: -- Cursor to fetch Postal address
2680: cursor csr_postal_address(p_person_id number, l_effective_date date) is

Line 2756: l_location_code hr_locations.location_code%type;

2752:
2753: l_period_recon varchar2(30); -- 9877034 fix
2754: l_period_recon_last_date date; -- 9877034 fix
2755:
2756: l_location_code hr_locations.location_code%type;
2757:
2758: begin
2759: hr_utility.set_location('Entering '||l_proc,10);
2760: select ppa.legislative_parameters