APPS.PAY_US_HR_HELPDESK dependencies on PAY_US_STATES

Line 55: (select state_name from pay_us_states where state_abbrev = region_2)

51: -- Cursor to fetch Work Location State details
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