DBA Data[Home] [Help]

APPS.PQH_RLS_BUS dependencies on PER_BUSINESS_GROUPS

Line 78: from per_business_groups pbg

74: -- Declare cursor
75: --
76: cursor csr_sec_grp is
77: select pbg.security_group_id
78: from per_business_groups pbg
79: ,pqh_roles rls
80: where
81: rls.role_id = p_role_id
82: and pbg.business_group_id = rls.business_group_id;

Line 139: from per_business_groups pbg

135: -- Declare cursor
136: --
137: cursor csr_leg_code is
138: select pbg.legislation_code
139: from per_business_groups pbg
140: ,pqh_roles rls
141: where
142: rls.role_id = p_role_id
143: and pbg.business_group_id = rls.business_group_id;