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_LOCATIONS_ALL

Line 133: ,hr_locations_all loc

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)
137: AND loc.location_id = NVL(p_location_id,loc.location_id)

Line 537: ,hr_locations_all loc

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
541: AND 'PQP_GB_EDU_ESTB_INFO'= lei.information_type ;