DBA Data[Home] [Help]

APPS.PAY_DK_BIK_UTILITY dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 224: p_vehicle_allot_id pqp_vehicle_allocations_f.VEHICLE_ALLOCATION_ID%TYPE,

220: FUNCTION get_vehicle_info
221: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
222: p_business_group_id in number,
223: p_date_earned DATE,
224: p_vehicle_allot_id pqp_vehicle_allocations_f.VEHICLE_ALLOCATION_ID%TYPE,
225: p_lic_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE,
226: p_buying_date OUT NOCOPY pqp_vehicle_repository_f.LAST_REGISTRATION_RENEW_DATE%TYPE,
227: p_buying_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE
228: )

Line 241: from pqp_vehicle_allocations_f pva

237: ,pvr.LIST_PRICE
238: INTO p_lic_reg_date
239: ,p_buying_date
240: ,p_buying_price
241: from pqp_vehicle_allocations_f pva
242: ,pqp_vehicle_repository_f pvr
243: where pva.assignment_id = p_assignment_id
244: and pvr.vehicle_repository_id = pva.vehicle_repository_id
245: and pva.business_group_id = p_business_group_id