APPS.PAY_KW_ANNUAL_REPORTS dependencies on HR_LOCATIONS

Line 167: from hr_locations

163:
164: /* Cursor for fetching Employer's Address */
165: CURSOR csr_get_address (l_location_id number) IS
166: select address_line_1 || decode(address_line_2,null,null,',') || address_line_2 , postal_code
167: from hr_locations
168: where location_id = l_location_id;
169:
170: /* Cursor for fetching person's full name */
171: CURSOR csr_get_full_name (l_person_id number, l_effective_date date) IS