APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on HR_LOOKUPS

Line 647: hr_lookups hl

643: CURSOR get_fuel_type IS
644: SELECT hl.description --pvd.fuel_type -- Bug 5017957
645: FROM pqp_assignment_attributes_f paaf,
646: pqp_vehicle_details pvd,
647: hr_lookups hl
648: WHERE l_ben_start_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
649: AND paaf.assignment_id = p_assignment_id -- comes from context
650: AND pvd.vehicle_details_id = paaf.primary_company_car
651: AND hl.lookup_type = 'PQP_FUEL_TYPE'

Line 658: FROM hr_lookups -- Bug fix 3799560

654: AND trunc(sysdate) BETWEEN trunc(nvl(hl.start_date_active, sysdate-1)) AND trunc(nvl(hl.end_date_active, sysdate+1));
655: --
656: CURSOR get_translation IS
657: SELECT Meaning
658: FROM hr_lookups -- Bug fix 3799560
659: WHERE lookup_type = 'GB_FUEL_TYPE'
660: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate-1)) AND trunc(nvl(end_date_active, sysdate+1))
661: AND enabled_flag = 'Y'
662: AND description = l_fuel_type

Line 1162: hr_lookups h1, -- Bug fix 3799560

1158: decode(nvl(pvd.market_value_classic_car,0), 0, pvd.accessory_value_at_startdate, 0) optional_accessory,
1159: pvd.accessory_value_added_later,
1160: pvd.engine_capacity_in_cc
1161: FROM pqp_vehicle_details pvd,
1162: hr_lookups h1, -- Bug fix 3799560
1163: hr_lookups h2
1164: WHERE pvd.vehicle_details_id = p_vehicle_details_id
1165: AND pvd.fuel_type = h2.lookup_code
1166: AND h2.lookup_type = 'PQP_FUEL_TYPE'

Line 1163: hr_lookups h2

1159: pvd.accessory_value_added_later,
1160: pvd.engine_capacity_in_cc
1161: FROM pqp_vehicle_details pvd,
1162: hr_lookups h1, -- Bug fix 3799560
1163: hr_lookups h2
1164: WHERE pvd.vehicle_details_id = p_vehicle_details_id
1165: AND pvd.fuel_type = h2.lookup_code
1166: AND h2.lookup_type = 'PQP_FUEL_TYPE'
1167: AND h2.enabled_flag = 'Y'

Line 1983: hr_lookups hl

1979: CURSOR get_fuel_type IS
1980: SELECT hl.description -- pvd.fuel_type
1981: FROM pqp_vehicle_allocations_f paaf,
1982: pqp_vehicle_repository_f pvd,
1983: hr_lookups hl
1984: WHERE paaf.assignment_id = p_assignment_id -- comes from context
1985: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
1986: AND pvd.vehicle_type = 'C'
1987: AND pvd.vehicle_ownership = 'C'

Line 1999: FROM hr_lookups --Bug fix 3799560

1995: ORDER BY pvd.effective_end_date desc;
1996: --
1997: CURSOR get_translation IS
1998: SELECT Meaning
1999: FROM hr_lookups --Bug fix 3799560
2000: WHERE lookup_type = 'GB_FUEL_TYPE'
2001: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate-1)) AND trunc(nvl(end_date_active, sysdate+1))
2002: AND enabled_flag = 'Y'
2003: AND description = l_fuel_type

Line 2643: hr_lookups h1, --Bug fix 3799560

2639: --bug 7306948 end
2640: accessory_value_added_later,
2641: engine_capacity_in_cc
2642: FROM pqp_vehicle_repository_f pvd,
2643: hr_lookups h1, --Bug fix 3799560
2644: hr_lookups h2
2645: WHERE vehicle_repository_id = p_vehicle_repository_id
2646: AND fuel_type = h1.lookup_code
2647: AND h1.lookup_type = 'PQP_FUEL_TYPE'

Line 2644: hr_lookups h2

2640: accessory_value_added_later,
2641: engine_capacity_in_cc
2642: FROM pqp_vehicle_repository_f pvd,
2643: hr_lookups h1, --Bug fix 3799560
2644: hr_lookups h2
2645: WHERE vehicle_repository_id = p_vehicle_repository_id
2646: AND fuel_type = h1.lookup_code
2647: AND h1.lookup_type = 'PQP_FUEL_TYPE'
2648: AND h1.enabled_flag = 'Y'