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.PER_INC_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2125: from hr_all_organization_units hou

2121: -- get valid organizations with class of rep body.
2122: --
2123: cursor c_org is
2124: select null
2125: from hr_all_organization_units hou
2126: where hou.organization_id = p_notified_rep_org_id
2127: and hou.internal_external_flag = 'EXT'
2128: and hou.business_group_id = p_business_group_id
2129: and nvl(p_notified_rep_date, hou.date_from) between hou.date_from

Line 3130: from hr_all_organization_units units

3126: --PER_US_OSHA_NUMBERS table.
3127: --
3128: cursor csr_us_bg is
3129: select business_group_id
3130: from hr_all_organization_units units
3131: ,hr_organization_information org
3132: where units.organization_id = org.organization_id
3133: --and units.type = 'BG'
3134: and mod(business_group_id,p_number_of_workers) = p_current_worker-1