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: p_green_environment_fee OUT NOCOPY number -- 9676720 fix

Line 244: from pqp_vehicle_allocations_f pva

240: INTO p_lic_reg_date
241: ,p_buying_date
242: ,p_buying_price
243: ,p_green_environment_fee -- 9079593 fix
244: from pqp_vehicle_allocations_f pva
245: ,pqp_vehicle_repository_f pvr
246: where pva.assignment_id = p_assignment_id
247: and pvr.vehicle_repository_id = pva.vehicle_repository_id
248: and pva.business_group_id = p_business_group_id