[Home] [Help]
26: OR va.effective_end_date BETWEEN g_start_date AND g_end_date)
27: OR (g_start_date BETWEEN va.effective_start_date AND va.effective_end_date
28: AND g_end_date BETWEEN va.effective_start_date AND va.effective_end_date) )
29: AND 'C' = (SELECT vr.vehicle_type
30: FROM pqp_vehicle_repository_f vr
31: WHERE vr.vehicle_repository_id =
32: va.vehicle_repository_id
33: AND vr.vehicle_ownership = 'C'
34: AND va.effective_start_date
42: FROM pay_all_payrolls_f papf,
43: hr_soft_coding_keyflex sck,
44: per_all_assignments_f paaf,
45: per_all_assignments_f paaf2,
46: Pqp_vehicle_repository_f vr,
47: Pqp_vehicle_allocations_f va
48: WHERE paaf2.assignment_id = p_assignment_id
49: AND paaf2.person_id = paaf.person_id
50: AND p_eff_date
82: --
83: CURSOR c_primary_car(p_assignment_id IN NUMBER, p_eff_date IN DATE) IS
84: SELECT va.vehicle_allocation_id,
85: vr.vehicle_repository_id
86: FROM Pqp_vehicle_repository_f vr,
87: Pqp_vehicle_allocations_f va
88: WHERE va.assignment_id = p_assignment_id
89: AND p_eff_date
90: BETWEEN va.effective_start_date
109: vr.model,
110: vr.engine_capacity_in_cc,
111: va.effective_end_date
112: FROM Pqp_vehicle_allocations_f va,
113: pqp_vehicle_repository_f vr
114: WHERE va.assignment_id = p_assignment_id
115: AND va.effective_end_date
116: BETWEEN (p_new_car_start_date - 30)
117: AND (p_new_car_start_date - 1)
142: vr.model,
143: vr.engine_capacity_in_cc,
144: va.effective_end_date
145: FROM Pqp_vehicle_allocations_f va,
146: pqp_vehicle_repository_f vr
147: WHERE va.assignment_id = p_assignment_id
148: AND va.effective_start_date
149: BETWEEN (p_withdrawn_car_end_date + 1)
150: AND least((p_withdrawn_car_end_date + 30), g_end_date)
170: p_vehicle_repository_id IN NUMBER) IS
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'
180: AND h1.enabled_flag = 'Y'
181: AND trunc(sysdate) BETWEEN trunc(nvl(h1.start_date_active, sysdate-1)) AND trunc(nvl(h1.end_date_active,sysdate+1))
182: AND EXISTS (SELECT 1
183: FROM pqp_vehicle_repository_f vr2
184: WHERE vr2.vehicle_repository_id =
185: p_vehicle_repository_id
186: AND vr2.effective_end_date =
187: vr1.effective_start_date-1
194: va.vehicle_repository_id,
195: va.usage_type usage_type,
196: va.effective_start_date,
197: va.effective_end_date
198: FROM Pqp_vehicle_repository_f vr,
199: Pqp_vehicle_allocations_f va
200: WHERE va.assignment_id = p_assignment_id
201: AND p_eff_date BETWEEN va.effective_start_date AND va.effective_end_date
202: AND va.vehicle_repository_id = vr.vehicle_repository_id
556: FROM hr_soft_coding_keyflex flex,
557: per_all_assignments_f asg,
558: pay_payrolls_f ppf,
559: pqp_vehicle_allocations_f va,
560: pqp_vehicle_repository_f vr
561: WHERE asg.person_id BETWEEN stperson AND endperson
562: AND asg.business_group_id = g_business_group_id
563: AND asg.payroll_id = nvl(g_payroll_id,asg.payroll_id)
564: AND asg.payroll_id = ppf.payroll_id
1021: FROM hr_soft_coding_keyflex flex,
1022: per_all_assignments_f asg,
1023: pay_payrolls_f ppf,
1024: pqp_vehicle_allocations_f va,
1025: pqp_vehicle_repository_f vr
1026: WHERE asg.person_id BETWEEN stperson AND endperson
1027: AND asg.business_group_id = g_business_group_id
1028: AND asg.payroll_id = nvl(g_payroll_id,asg.payroll_id)
1029: AND asg.payroll_id = ppf.payroll_id
1529: fiscal_ratings_uom,
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