APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on HR_LOCATIONS

Line 160: FROM hr_locations

156: (p_location_id NUMBER) IS
157: SELECT rpad(Address_line_1 || ', ' || Address_line_2 ||', ' ||Address_line_3,30,' ') address,
158: hr_general.DECODE_FND_COMM_LOOKUP('SE_POSTAL_CODE',postal_code) postal_code,
159: hr_general.decode_territory (country) country
160: FROM hr_locations
161: WHERE location_id = p_location_id;
162:
163: CURSOR csr_le_contact_person
164: (p_legal_employer_id IN NUMBER) IS