APPS.HR_US_REPORTS dependencies on PAY_US_STATES

Line 102: 40.24 28-Jul-1997 nlee Change pay_state_rules to pay_us_states in get_state_name.

98: the latest name in the effective_start_date and this will solve
99: the problem of fetching more than one row.
100:
101: 40.23 26-FEB-1997 hekim In get_address_3lines, take substring of city name
102: 40.24 28-Jul-1997 nlee Change pay_state_rules to pay_us_states in get_state_name.
103: Change the selection of all rows from hr_locations and
104: per_addresses in get_address and get_employee_address
105: functions to selection of the specific rows that are
106: needed to increase performance and avoid overflow problem.

Line 1458: FROM pay_us_states

1454: hr_utility.set_location('Entered hr_us_reports.get_state_name',5);
1455: --
1456: SELECT state_name
1457: INTO l_state_name
1458: FROM pay_us_states
1459: WHERE state_abbrev = p_state_code;
1460: --
1461: hr_utility.set_location('Leaving hr_us_reports.get_state_name',10);
1462: --