DBA Data[Home] [Help]

APPS.PAY_GB_EDI_P46_CAR dependencies on HR_LOOKUPS

Line 175: hr_lookups h1

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

Line 1534: hr_lookups h1

1530: shared_vehicle,
1531: vehicle_status,
1532: taxation_method
1533: FROM pqp_vehicle_repository_f,
1534: hr_lookups h1
1535: WHERE vehicle_repository_id = p_vehicle_repository_id
1536: AND l_eff_date BETWEEN effective_start_date AND effective_end_Date
1537: AND fuel_type = h1.lookup_code
1538: AND h1.lookup_type = 'PQP_FUEL_TYPE'