APPS.PQP_VRI_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 30: -- pqp_veh_repos_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_repos_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_repos_extra_info vri
39: -- , EDIT_HERE table_name(s) 333
40: where vri.veh_repos_extra_info_id = p_veh_repos_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_repository_f vre
110: WHERE vre.vehicle_repository_id = p_vehicle_repository_id
111: AND pbg.business_group_id=vre.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_repository_f vre
184: where vre.vehicle_repository_id = p_vehicle_repository_id
185: and pbg.business_group_id = vre.business_group_id ;
186: --