APPS.PQP_GENERIC_EIT_SS dependencies on PQP_VEHICLE_REPOSITORY_F

Line 1563: FROM pqp_vehicle_repository_f pvr

1559: l_get_other_tstep c_get_other_tstep%ROWTYPE;
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