APPS.PQP_PL_VEHICLE_ALLOCATIONS dependencies on PQP_VEHICLE_REPOSITORY_F

Line 12: pqp_vehicle_repository_f pvr

8: ) is
9: cursor csr_veh_type is
10: select pvr.vehicle_type,pvr.vehicle_ownership
11: from
12: pqp_vehicle_repository_f pvr
13: where
14: pvr.vehicle_repository_id = p_vehicle_repository_id
15: and p_effective_date between pvr.effective_start_date and pvr.effective_end_date;
16:

Line 22: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%type;

18: where ci.legislation_code = 'PL'
19: and ci.user_column_instance_id = p_val_information2
20: and p_effective_date between ci.effective_start_date and ci.effective_end_date;
21:
22: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%type;
23: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;
24: l_mileage_value number;
25: l_proc varchar2(72); -- Variable used when data is uploaded directly by api
26:

Line 23: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;

19: and ci.user_column_instance_id = p_val_information2
20: and p_effective_date between ci.effective_start_date and ci.effective_end_date;
21:
22: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%type;
23: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;
24: l_mileage_value number;
25: l_proc varchar2(72); -- Variable used when data is uploaded directly by api
26:
27: BEGIN