APPS.HR_NO_UTILITY dependencies on PQP_VEHICLE_REPOSITORY_F

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

687:
688: FUNCTION get_vehicle_info
689: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
690: p_date_earned DATE,
691: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
692: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
693: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
694: )
695: return NUMBER

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

688: FUNCTION get_vehicle_info
689: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
690: p_date_earned DATE,
691: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
692: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
693: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
694: )
695: return NUMBER
696: IS

Line 693: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE

689: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
690: p_date_earned DATE,
691: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
692: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
693: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
694: )
695: return NUMBER
696: IS
697: l_value NUMBER;

Line 708: ,pqp_vehicle_repository_f pvr

704: INTO p_list_price
705: ,p_reg_number
706: ,p_reg_date
707: from pqp_vehicle_allocations_f pva
708: ,pqp_vehicle_repository_f pvr
709: where pva.assignment_id = p_assignment_id
710: and pvr.vehicle_repository_id = pva.vehicle_repository_id
711: and p_date_earned between pva.EFFECTIVE_START_DATE and pva.EFFECTIVE_END_DATE
712: and p_date_earned between pvr.EFFECTIVE_START_DATE and pvr.EFFECTIVE_END_DATE;