APPS.HR_PERSON_RECORD dependencies on PAY_US_STATES

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

1982:
1983:
1984: cursor csr_state_det(p_location_id number) is
1985: select region_2,location_code,
1986: (select state_name from pay_us_states where state_abbrev = region_2)
1987: from hr_locations_all
1988: where location_id = p_location_id;
1989:
1990: p_location_name varchar2(100);