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 540: ,pqp_vehicle_allocations_f pva

536: SELECT paa.assignment_id
537: ,pva.object_version_number ovn
538: ,pva.vehicle_allocation_id
539: FROM per_all_assignments_f paa
540: ,pqp_vehicle_allocations_f pva
541: WHERE paa.person_id =(SELECT paa1.person_id
542: FROM per_all_assignments_f paa1
543: WHERE paa1.assignment_id=p_assignment_id
544: AND paa1.business_group_id=p_business_group_id

Line 799: ,pqp_vehicle_allocations_f pva

795: IS
796: SELECT paa.assignment_id
797: ,pva.object_version_number ovn
798: FROM per_all_assignments_f paa
799: ,pqp_vehicle_allocations_f pva
800: WHERE EXISTS (SELECT paa1.person_id
801: FROM per_all_assignments_f paa1
802: ,pqp_vehicle_allocations_f pva1
803: WHERE pva1.vehicle_allocation_id=p_vehicle_allocation_id

Line 802: ,pqp_vehicle_allocations_f pva1

798: FROM per_all_assignments_f paa
799: ,pqp_vehicle_allocations_f pva
800: WHERE EXISTS (SELECT paa1.person_id
801: FROM per_all_assignments_f paa1
802: ,pqp_vehicle_allocations_f pva1
803: WHERE pva1.vehicle_allocation_id=p_vehicle_allocation_id
804: AND pva1.vehicle_repository_id=pva.vehicle_repository_id
805: AND paa1.assignment_id=pva1.assignment_id
806: AND paa1.business_group_id=pva1.business_group_id