APPS.PAY_KW_ANNUAL_REPORTS dependencies on HR_LOCATIONS

Line 152: from hr_locations

148:
149: /* Cursor for fetching Employer's Address */
150: CURSOR csr_get_address (l_location_id number) IS
151: select address_line_1 || decode(address_line_2,null,null,',') || address_line_2 , postal_code
152: from hr_locations
153: where location_id = l_location_id;
154:
155: /* Cursor for fetching person's full name */
156: CURSOR csr_get_full_name (l_person_id number, l_effective_date date) IS