APPS.PAY_DK_BIK_UTILITY dependencies on PQP_VEHICLE_REPOSITORY_F

Line 225: p_lic_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE,

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: )
229: return NUMBER

Line 226: p_buying_date OUT NOCOPY pqp_vehicle_repository_f.LAST_REGISTRATION_RENEW_DATE%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: )
229: return NUMBER
230: IS

Line 227: p_buying_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE

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: )
229: return NUMBER
230: IS
231: l_value NUMBER;

Line 242: ,pqp_vehicle_repository_f pvr

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
246: and pva.vehicle_allocation_id = p_vehicle_allot_id