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.PAY_US_GET_ITEM_DATA_PKG dependencies on HR_LOCATIONS_ALL

Line 66: or TABLE HR_LOCATIONS_ALL depending on condition

62: * get_report_name_address_eod
63: 23-AUG-06 sausingh 115.14 4939049 Modified the following cursors to
64: retrieve the country code from the
65: lookup 'PQP_US_COUNTRY_TRANSLATE'
66: or TABLE HR_LOCATIONS_ALL depending on condition
67: * get_organization_name_address
68: 21-Sep-06 ppanda 115.15 Following cursors were opened but not closed.
69: * get_mmref_name_address_eod
70: * get_report_name_address_eod

Line 1015: FROM hr_locations_all hl,

1011: nvl(substr(hrl.meaning, -2),hl.country) country_code,
1012: hl.region_1,
1013: hl.region_2,
1014: 'Y' valid_address
1015: FROM hr_locations_all hl,
1016: hr_lookups hrl,
1017: hr_all_organization_units hou
1018: WHERE hou.organization_id = c_organization_id
1019: AND hl.location_id = hou.location_id