APPS.PQP_VAI_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 30: -- pqp_veh_alloc_extra_info and PER_BUSINESS_GROUPS_PERF

26: --
27: -- Declare cursor
28: --
29: -- EDIT_HERE In the following cursor statement add join(s) between
30: -- pqp_veh_alloc_extra_info and PER_BUSINESS_GROUPS_PERF
31: -- so that the security_group_id for
32: -- the current business group context can be derived.
33: -- Remove this comment when the edit has been completed.
34: cursor csr_sec_grp is

Line 37: from per_business_groups_perf pbg

33: -- Remove this comment when the edit has been completed.
34: cursor csr_sec_grp is
35: select pbg.security_group_id,
36: pbg.legislation_code
37: from per_business_groups_perf pbg
38: , pqp_veh_alloc_extra_info vai
39: -- , EDIT_HERE table_name(s) 333
40: where vai.veh_alloc_extra_info_id = p_veh_alloc_extra_info_id;
41: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 108: from per_business_groups_perf pbg

104: -- Declare cursor
105: --
106: cursor csr_leg_code is
107: select pbg.legislation_code
108: from per_business_groups_perf pbg
109: ,pqp_vehicle_allocations_f pva
110: where pva.vehicle_allocation_id = p_vehicle_allocation_id
111: and pbg.business_group_id = pva.business_group_id;
112: --

Line 182: from per_business_groups_perf pbg

178: -- Declare cursor
179: --
180: cursor csr_leg_code is
181: select pbg.legislation_code
182: from per_business_groups_perf pbg
183: , pqp_vehicle_allocations_f val
184: where val.vehicle_allocation_id = p_vehicle_allocation_id
185: AND pbg.business_group_id=val.business_group_id ;
186: --