APPS.HR_JP_GENERAL_PKG dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 272: from pqp_vehicle_allocations_f pva,

268: IS
269: l_name PQP_VEHICLE_REPOSITORY_F.REGISTRATION_NUMBER%TYPE;
270: CURSOR cur_vehicle_name IS
271: select pvr.registration_number
272: from pqp_vehicle_allocations_f pva,
273: pqp_vehicle_repository_f pvr
274: where pva.vehicle_allocation_id=p_vehicle_allocation_id
275: and p_effective_date
276: between pva.effective_start_date and nvl(pva.effective_end_date,p_effective_date)