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 PQP_VEHICLE_ALLOCATIONS_F

Line 23: FROM pqp_vehicle_allocations_f va

19: Vehicle_repository_id,
20: Usage_type,
21: effective_start_date,
22: effective_end_date
23: FROM pqp_vehicle_allocations_f va
24: WHERE va.assignment_id = p_assignment_id
25: AND ( (va.effective_start_date BETWEEN g_start_date AND g_end_date
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

Line 47: Pqp_vehicle_allocations_f va

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
51: BETWEEN paaf.effective_start_date

Line 78: FROM pqp_vehicle_allocations_f va

74: --
75: CURSOR c_alloc_dates(p_vehicle_allocation_id NUMBER) IS
76: SELECT min(effective_start_Date) min_start_date,
77: max(effective_end_date) max_end_Date
78: FROM pqp_vehicle_allocations_f va
79: WHERE va.vehicle_allocation_id = p_vehicle_allocation_id;
80: --
81: alc_dates_rec c_alloc_dates%ROWTYPE;
82: --

Line 87: Pqp_vehicle_allocations_f va

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
91: AND va.effective_end_date

Line 112: FROM Pqp_vehicle_allocations_f va,

108: vr.make,
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)

Line 121: FROM Pqp_vehicle_allocations_f va2

117: AND (p_new_car_start_date - 1)
118: AND va.usage_type = 'P'
119: AND va.effective_end_date =
120: (SELECT max(va2.effective_end_date)
121: FROM Pqp_vehicle_allocations_f va2
122: WHERE va2.assignment_id = p_assignment_id
123: AND va2.effective_end_date
124: BETWEEN (p_new_car_start_date - 30)
125: AND (p_new_car_start_date - 1)

Line 145: FROM Pqp_vehicle_allocations_f va,

141: vr.make,
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)

Line 154: FROM Pqp_vehicle_allocations_f va2

150: AND least((p_withdrawn_car_end_date + 30), g_end_date)
151: AND va.usage_type = 'P'
152: AND va.effective_start_date =
153: (SELECT min(va2.effective_start_date)
154: FROM Pqp_vehicle_allocations_f va2
155: WHERE va2.assignment_id = p_assignment_id
156: AND va2.effective_start_date
157: BETWEEN (p_withdrawn_car_end_date + 1)
158: AND least((p_withdrawn_car_end_date + 30), g_end_date)

Line 199: Pqp_vehicle_allocations_f va

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
203: AND p_eff_date BETWEEN vr.effective_start_date AND vr.effective_end_date

Line 551: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)

547: FROM pay_payroll_actions
548: WHERE payroll_action_id = pactid;
549: --
550: CURSOR c_asg IS
551: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)
552: */
553: asg.assignment_id,
554: min(asg.effective_start_date) asg_min_start_date,
555: max(asg.effective_end_date) asg_max_end_date

Line 559: pqp_vehicle_allocations_f va,

555: max(asg.effective_end_date) asg_max_end_date
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)

Line 1016: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)

1012: FROM pay_payroll_actions
1013: WHERE payroll_action_id = pactid;
1014: --
1015: CURSOR c_asg IS
1016: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)
1017: */
1018: asg.assignment_id,
1019: min(asg.effective_start_date) asg_min_start_date,
1020: max(asg.effective_end_date) asg_max_end_date

Line 1024: pqp_vehicle_allocations_f va,

1020: max(asg.effective_end_date) asg_max_end_date
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)

Line 1506: FROM pqp_vehicle_allocations_f

1502: CURSOR c_alloc IS
1503: SELECT capital_contribution,
1504: private_contribution,
1505: fuel_benefit
1506: FROM pqp_vehicle_allocations_f
1507: WHERE vehicle_allocation_id = p_vehicle_allocation_id
1508: AND l_eff_date between effective_start_date
1509: and effective_end_Date;
1510: --