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

Line 120: FROM hr_all_organization_units hou

116:
117: CURSOR csr_get_pb_name
118: IS
119: SELECT hou.name
120: FROM hr_all_organization_units hou
121: ,hr_organization_information hoi
122: WHERE hou.organization_id = p_organization_id
123: AND nvl(hou.business_group_id, p_business_group_id)
124: = p_business_group_id

Line 272: FROM hr_all_organization_units hou

268:
269: CURSOR csr_get_udt_id
270: IS
271: SELECT TO_NUMBER(hoi.org_information1)
272: FROM hr_all_organization_units hou
273: ,hr_organization_information hoi
274: WHERE hou.organization_id = hoi.organization_id
275: AND hou.organization_id = TO_NUMBER(p_organization_id)
276: AND nvl(hou.business_group_id, p_business_group_id)