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.PQP_GENERIC_EIT_SS dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 151: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;

147:
148:
149: l_object_version_number1 NUMBER;
150: l_object_version_number NUMBER;
151: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
152: l_lookup_code hr_lookups.lookup_code%TYPE;
153: l_leg_code pqp_configuration_values.legislation_code%TYPE;
154: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
155: l_correction NUMBER;

Line 1564: ,pqp_vehicle_allocations_f pva

1560: CURSOR c_get_details IS
1561: SELECT pvr.vehicle_repository_id
1562: ,pva.vehicle_allocation_id
1563: FROM pqp_vehicle_repository_f pvr
1564: ,pqp_vehicle_allocations_f pva
1565: WHERE pvr.vehicle_repository_id =pva.vehicle_repository_id
1566: AND pva.assignment_id =l_assignment_id
1567: AND NVL(l_effective_date,SYSDATE) BETWEEN pvr.effective_start_date
1568: AND pvr.effective_end_date