eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

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: p_green_environment_fee OUT NOCOPY number -- 9676720 fix
229: )
230: return NUMBER

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: p_green_environment_fee OUT NOCOPY number -- 9676720 fix
229: )
230: return NUMBER
231: IS

Line 245: ,pqp_vehicle_repository_f pvr

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