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_VEH_MULTI_ALLOC dependencies on PER_ALL_ASSIGNMENTS_F

Line 343: FROM per_all_assignments_f paa

339:
340: CURSOR c_get_asg
341: IS
342: SELECT paa.assignment_id
343: FROM per_all_assignments_f paa
344: WHERE paa.person_id =(SELECT paa1.person_id
345: FROM per_all_assignments_f paa1
346: WHERE paa1.assignment_id=p_assignment_id
347: AND paa1.business_group_id=p_business_group_id

Line 345: FROM per_all_assignments_f paa1

341: IS
342: SELECT paa.assignment_id
343: FROM per_all_assignments_f paa
344: WHERE paa.person_id =(SELECT paa1.person_id
345: FROM per_all_assignments_f paa1
346: WHERE paa1.assignment_id=p_assignment_id
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)

Line 544: FROM per_all_assignments_f paa

540: IS
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

Line 547: FROM per_all_assignments_f paa1

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
550: AND p_effective_date BETWEEN paa1.effective_start_date
551: AND paa1.effective_end_date)

Line 803: FROM per_all_assignments_f paa

799: CURSOR c_get_asg
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

Line 806: FROM per_all_assignments_f paa1

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
809: AND pva1.vehicle_repository_id=pva.vehicle_repository_id
810: AND paa1.assignment_id=pva1.assignment_id