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 HR_ALL_ORGANIZATION_UNITS

Line 141: 115.18 19-OCT-2009 nchinnam 8836078 Added hr_all_organization_units for payee

137: check_if_top_org cursor and csr_tax_unit_flag cursor.
138: 115.15 10-OCT-2006 rpasumar 5577840 Modified verify_state function.
139: 115.16 11-OCT-2006 rpasumar 5577840 Selected hierarchy_node_id instead of entity_id in c_est_entity cursor of the function verify_state.
140: 115.17 12-MAR-2008 psugumar 6774707 Added get_employee_address40
141: 115.18 19-OCT-2009 nchinnam 8836078 Added hr_all_organization_units for payee
142: Consolidate Report
143: 115.19 22-JUL-2010 nkjaladi 9912897 Commented debug DML statement in procedure get_employee_address
144: Also modified the procedure get_employee_address and function
145: break_address_line to use chr(10) instead of rpad it to 30

Line 184: hr_all_organization_units hou

180:
181: CURSOR c_get_o_payee IS
182: SELECT SUBSTR(hou.name,1,240)
183: FROM hr_locations loc,
184: hr_all_organization_units hou
185: WHERE hou.organization_id = IN_payee_id
186: AND hou.business_group_id = IN_business_group_id
187: AND IN_payment_date BETWEEN hou.date_from
188: AND NVL(hou.date_to, IN_payment_date)