APPS.PQP_VEH_MULTI_ALLOC dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 351: FROM pqp_vehicle_allocations_f pva

347: AND paa1.business_group_id=p_business_group_id
348: AND p_effective_date BETWEEN paa1.effective_start_date
349: AND paa1.effective_end_date)
350: AND NOT EXISTS (SELECT 'X'
351: FROM pqp_vehicle_allocations_f pva
352: WHERE pva.vehicle_repository_id=p_vehicle_repository_id
353: AND p_effective_date BETWEEN pva.effective_start_date
354: AND pva.effective_end_date
355: and pva.assignment_id =paa.assignment_id

Line 545: ,pqp_vehicle_allocations_f pva

541: SELECT paa.assignment_id
542: ,pva.object_version_number ovn
543: ,pva.vehicle_allocation_id
544: FROM per_all_assignments_f paa
545: ,pqp_vehicle_allocations_f pva
546: WHERE paa.person_id =(SELECT paa1.person_id
547: FROM per_all_assignments_f paa1
548: WHERE paa1.assignment_id=p_assignment_id
549: AND paa1.business_group_id=p_business_group_id

Line 804: ,pqp_vehicle_allocations_f pva

800: IS
801: SELECT paa.assignment_id
802: ,pva.object_version_number ovn
803: FROM per_all_assignments_f paa
804: ,pqp_vehicle_allocations_f pva
805: WHERE EXISTS (SELECT paa1.person_id
806: FROM per_all_assignments_f paa1
807: ,pqp_vehicle_allocations_f pva1
808: WHERE pva1.vehicle_allocation_id=p_vehicle_allocation_id

Line 807: ,pqp_vehicle_allocations_f pva1

803: FROM per_all_assignments_f paa
804: ,pqp_vehicle_allocations_f pva
805: WHERE EXISTS (SELECT paa1.person_id
806: FROM per_all_assignments_f paa1
807: ,pqp_vehicle_allocations_f pva1
808: WHERE pva1.vehicle_allocation_id=p_vehicle_allocation_id
809: AND pva1.vehicle_repository_id=pva.vehicle_repository_id
810: AND paa1.assignment_id=pva1.assignment_id
811: AND paa1.business_group_id=pva1.business_group_id