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 539: FROM per_all_assignments_f paa

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

Line 542: FROM per_all_assignments_f paa1

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

Line 798: FROM per_all_assignments_f paa

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

Line 801: FROM per_all_assignments_f paa1

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