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_LOCATION_EXTRA_INFO

Line 132: FROM hr_location_extra_info lei

128: ,lei.lei_information3 estb_name
129: ,lei.lei_information4 estb_type
130: ,lpad(lei.lei_information5,2,'0') school_number
131: ,lei.lei_information6 lea_number
132: FROM hr_location_extra_info lei
133: ,hr_locations_all loc
134: WHERE lei.information_type = 'PQP_GB_EDU_ESTB_INFO'
135: AND loc.business_group_id = NVL(p_business_group_id,g_business_group_id) -- Bug 2175986 NOT A BUG
136: AND loc.location_code = NVL(p_location_code,loc.location_code)

Line 536: FROM hr_location_extra_info lei

532: ,lei.lei_information3 estb_name
533: ,lei.lei_information4 estb_type
534: ,lpad(lei.lei_information5,2,'0') school_number
535: ,lei.lei_information6 lea_number
536: FROM hr_location_extra_info lei
537: ,hr_locations_all loc
538: WHERE loc.business_group_id = nvl(p_business_group_id,g_business_group_id)
539: AND loc.location_code = p_location_code
540: AND loc.location_id = lei.location_id