eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1476: FROM pay_us_states

1472: hr_utility.set_location('Entered hr_us_reports.get_state_name',5);
1473: --
1474: SELECT state_name
1475: INTO l_state_name
1476: FROM pay_us_states
1477: WHERE state_abbrev = p_state_code;
1478: --
1479: hr_utility.set_location('Leaving hr_us_reports.get_state_name',10);
1480: --