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_GB_TP_PENSION_EXTRACTS dependencies on HR_ORGANIZATION_UNITS

Line 87: ,hr_organization_units hou

83: ,p_organization_id, 0
84: ,hoi.organization_id) orgidcol -- added to Order by the result so that
85: -- the LEA at BG level comes first.
86: FROM hr_organization_information hoi
87: ,hr_organization_units hou
88: WHERE hoi.org_information_context = 'PQP_GB_EDU_AUTH_LEA_INFO'
89: AND hou.business_group_id = p_organization_id
90: AND hoi.organization_id = hou.organization_id
91: AND (( p_lea_number IS NOT NULL

Line 106: FROM hr_organization_units_v org

102: CURSOR csr_lea_details_by_loc (p_location_id IN NUMBER) IS
103: SELECT hoi.org_information1 lea_number
104: ,hoi.org_information2 lea_name
105: ,hoi.organization_id organization_id --Added for non-lea organizations.
106: FROM hr_organization_units_v org
107: ,hr_organization_information hoi
108: WHERE org.location_id = p_location_id
109: AND hoi.organization_id = org.organization_id
110: AND hoi.org_information_context = 'PQP_GB_EDU_AUTH_LEA_INFO';