APPS.PAY_US_HR_HELPDESK dependencies on HR_LOCATIONS_ALL

Line 56: from hr_locations_all

52:
53: cursor csr_state_det(p_location_id number) is
54: select region_2,location_code,
55: (select state_name from pay_us_states where state_abbrev = region_2)
56: from hr_locations_all
57: where location_id = p_location_id;
58:
59: -- Cursor to fetch legislation_code
60: