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.PAY_GB_EDI_P46_CAR dependencies on HR_LOOKUPS

Line 178: hr_lookups h1

174: SELECT effective_start_date,
175: effective_end_date,
176: h1.description fuel_type
177: FROM pqp_vehicle_repository_f vr1,
178: hr_lookups h1
179: WHERE vr1.vehicle_repository_id = p_vehicle_repository_id
180: AND vr1.effective_start_date BETWEEN g_start_date AND g_end_date
181: AND vr1.fuel_type = h1.lookup_code
182: AND h1.lookup_type = 'PQP_FUEL_TYPE'

Line 187: hr_lookups h2

183: AND h1.enabled_flag = 'Y'
184: AND trunc(sysdate) BETWEEN trunc(nvl(h1.start_date_active, sysdate-1)) AND trunc(nvl(h1.end_date_active,sysdate+1))
185: AND EXISTS (SELECT 1
186: FROM pqp_vehicle_repository_f vr2,
187: hr_lookups h2
188: WHERE vr2.vehicle_repository_id =
189: p_vehicle_repository_id
190: AND vr2.effective_end_date =
191: vr1.effective_start_date-1

Line 221: hr_lookups h1

217: SELECT effective_start_date,
218: effective_end_date,
219: h1.description fuel_type
220: FROM pqp_vehicle_repository_f vr1,
221: hr_lookups h1
222: WHERE vr1.vehicle_repository_id = p_vehicle_repository_id
223: AND vr1.effective_start_date BETWEEN g_start_date AND g_end_date
224: AND vr1.fuel_type = h1.lookup_code
225: AND h1.lookup_type = 'PQP_FUEL_TYPE'

Line 3001: hr_lookups h1

2997: shared_vehicle,
2998: vehicle_status,
2999: taxation_method
3000: FROM pqp_vehicle_repository_f,
3001: hr_lookups h1
3002: WHERE vehicle_repository_id = p_vehicle_repository_id
3003: AND l_eff_date BETWEEN effective_start_date AND effective_end_Date
3004: AND fuel_type = h1.lookup_code
3005: AND h1.lookup_type = 'PQP_FUEL_TYPE'