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.HR_JP_GENERAL_PKG dependencies on PQP_VEHICLE_REPOSITORY_F

Line 269: l_name PQP_VEHICLE_REPOSITORY_F.REGISTRATION_NUMBER%TYPE;

265: P_VEHICLE_ALLOCATION_ID IN NUMBER,
266: P_EFFECTIVE_DATE IN DATE)
267: RETURN VARCHAR2
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

Line 273: pqp_vehicle_repository_f pvr

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)
277: and pvr.vehicle_repository_id = pva.vehicle_repository_id