APPS.HR_NO_UTILITY dependencies on PQP_VEHICLE_REPOSITORY_F

Line 758: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,

754:
755: FUNCTION get_vehicle_info
756: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
757: p_date_earned DATE,
758: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
759: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
760: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
761: )
762: return NUMBER

Line 759: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,

755: FUNCTION get_vehicle_info
756: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
757: p_date_earned DATE,
758: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
759: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
760: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
761: )
762: return NUMBER
763: IS

Line 760: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE

756: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
757: p_date_earned DATE,
758: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
759: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
760: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
761: )
762: return NUMBER
763: IS
764: l_value NUMBER;

Line 775: ,pqp_vehicle_repository_f pvr

771: INTO p_list_price
772: ,p_reg_number
773: ,p_reg_date
774: from pqp_vehicle_allocations_f pva
775: ,pqp_vehicle_repository_f pvr
776: where pva.assignment_id = p_assignment_id
777: and pvr.vehicle_repository_id = pva.vehicle_repository_id
778: and p_date_earned between pva.EFFECTIVE_START_DATE and pva.EFFECTIVE_END_DATE
779: and p_date_earned between pvr.EFFECTIVE_START_DATE and pvr.EFFECTIVE_END_DATE;