APPS.PQP_VRE_BUS dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 1086: FROM pqp_vehicle_allocations_f

1082:
1083: --Getting the allocation count for repositoryId
1084: CURSOR c_alloc_count_cursor IS
1085: SELECT COUNT(vehicle_allocation_id)
1086: FROM pqp_vehicle_allocations_f
1087: WHERE vehicle_repository_id = p_rec.vehicle_repository_id
1088: AND (p_effective_date between effective_start_date and effective_end_date
1089: OR p_effective_date <= effective_start_date)
1090: AND business_group_id = p_rec.business_group_id;

Line 1132: FROM PQP_VEHICLE_ALLOCATIONS_F pva,pqp_vehicle_repository_f pvr

1128: ) RETURN NUMBER IS
1129: --Getting the vehicle allocation count for repositoryId
1130: CURSOR c_alloc_count_cursor IS
1131: SELECT pvr.vehicle_status ,1 test
1132: FROM PQP_VEHICLE_ALLOCATIONS_F pva,pqp_vehicle_repository_f pvr
1133: WHERE pva.vehicle_repository_id= p_vehicle_repository_id
1134: AND pva.vehicle_repository_id =pvr.vehicle_repository_id
1135: AND pva.business_group_id = pvr.business_group_id
1136: AND (p_effective_date between pva.effective_start_date

Line 1188: FROM pqp_vehicle_allocations_f pva

1184: --Getting the all personIds which are allocated to this
1185: --vehicle repositoryId
1186: CURSOR c_alloc_count_cursor IS
1187: SELECT paa.person_id
1188: FROM pqp_vehicle_allocations_f pva
1189: ,per_all_assignments_f paa
1190: WHERE pva.vehicle_repository_id=p_rec.vehicle_repository_id
1191: AND paa.assignment_id=pva.assignment_id
1192: AND pva.business_group_id=p_rec.business_group_id

Line 1313: FROM pqp_vehicle_allocations_f pva

1309: ) RETURN VARCHAR2 IS
1310: --Getting the allocation count for past ,future and current date tracks
1311: /*CURSOR c_pesron_names_cursor IS
1312: SELECT distinct papf.title ||' '||papf.first_name ||' '|| papf.last_name
1313: FROM pqp_vehicle_allocations_f pva
1314: ,per_all_assignments_f paa
1315: ,per_people_f papf
1316: WHERE pva.vehicle_repository_id=p_rec.vehicle_repository_id
1317: AND paa.assignment_id=pva.assignment_id

Line 1333: FROM pqp_vehicle_allocations_f pva

1329: OR p_effective_date <= pva.effective_start_date
1330: OR p_effective_date >= pva.effective_start_date ); */
1331: CURSOR c_pesron_names_cursor IS
1332: SELECT distinct hl.meaning ||' '||papf.first_name ||' '|| papf.last_name
1333: FROM pqp_vehicle_allocations_f pva
1334: ,per_all_assignments_f paa
1335: ,per_people_f papf
1336: ,hr_lookups hl
1337: WHERE pva.vehicle_repository_id=p_rec.vehicle_repository_id

Line 1391: FROM pqp_vehicle_allocations_f pva

1387:
1388: --Getting the allocation count for current and future date tracks
1389: CURSOR c_pesron_names_cursor IS
1390: SELECT distinct hl.meaning ||' '||papf.first_name ||' '|| papf.last_name
1391: FROM pqp_vehicle_allocations_f pva
1392: ,per_all_assignments_f paa
1393: ,per_people_f papf
1394: ,hr_lookups hl
1395: WHERE pva.vehicle_repository_id=p_rec.vehicle_repository_id