DBA Data[Home] [Help]

APPS.PQP_GB_VEHICLE_ALLOCATIONS dependencies on PQP_VEHICLE_REPOSITORY_F

Line 12: FROM pqp_vehicle_repository_f pvr

8: ,P_CAPITAL_CONTRIBUTION in NUMBER default 0 --Added for the bug 10020963
9: ,P_PRIVATE_CONTRIBUTION in NUMBER default 0) is --Added for the bug 10020963
10: cursor csr_veh_ownership_type is
11: select pvr.vehicle_ownership
12: FROM pqp_vehicle_repository_f pvr
13: where pvr.vehicle_repository_id = P_VEHICLE_REPOSITORY_ID
14: AND pvr.business_group_id = p_business_group_id
15: and P_EFFECTIVE_DATE between pvr.effective_start_date AND pvr.effective_end_date;
16:

Line 18: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;

14: AND pvr.business_group_id = p_business_group_id
15: and P_EFFECTIVE_DATE between pvr.effective_start_date AND pvr.effective_end_date;
16:
17:
18: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;
19:
20: BEGIN
21:
22: open csr_veh_ownership_type;