APPS.PQP_VAL_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 879: FROM per_all_assignments_f paa

875: l_exist VARCHAR2(1);
876: Begin
877: SELECT 'X'
878: INTO l_exist
879: FROM per_all_assignments_f paa
880: WHERE paa.assignment_id =p_rec.assignment_id
881: AND paa.business_group_id=p_rec.business_group_id
882: AND p_effective_date BETWEEN paa.effective_start_date
883: AND paa.effective_end_date;

Line 1055: per_all_assignments_f paa

1051:
1052: CURSOR c_person_alloc_count_cursor IS
1053: SELECT COUNT(pva.vehicle_allocation_id)
1054: FROM pqp_vehicle_allocations_f pva,
1055: per_all_assignments_f paa
1056: WHERE paa.assignment_id = pva.assignment_id
1057: AND pva.assignment_id NOT IN ( SELECT assignment_id
1058: FROM per_all_assignments_f
1059: WHERE person_id = (SELECT DISTINCT person_id

Line 1058: FROM per_all_assignments_f

1054: FROM pqp_vehicle_allocations_f pva,
1055: per_all_assignments_f paa
1056: WHERE paa.assignment_id = pva.assignment_id
1057: AND pva.assignment_id NOT IN ( SELECT assignment_id
1058: FROM per_all_assignments_f
1059: WHERE person_id = (SELECT DISTINCT person_id
1060: FROM per_all_assignments_f
1061: WHERE assignment_id=p_rec.assignment_id))
1062: AND pva.vehicle_repository_id = p_rec.vehicle_repository_id

Line 1060: FROM per_all_assignments_f

1056: WHERE paa.assignment_id = pva.assignment_id
1057: AND pva.assignment_id NOT IN ( SELECT assignment_id
1058: FROM per_all_assignments_f
1059: WHERE person_id = (SELECT DISTINCT person_id
1060: FROM per_all_assignments_f
1061: WHERE assignment_id=p_rec.assignment_id))
1062: AND pva.vehicle_repository_id = p_rec.vehicle_repository_id
1063: AND pva.business_group_id=p_rec.business_group_id
1064: AND p_effective_date BETWEEN