DBA Data[Home] [Help]

APPS.PQH_REI_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_role_extra_info rei
31: , pqh_roles rls
32: where rei.role_extra_info_id = p_role_extra_info_id
33: and rei.role_id = rls.role_id

Line 95: from per_business_groups pbg

91: -- Declare cursor
92: --
93: cursor csr_leg_code is
94: select pbg.legislation_code
95: from per_business_groups pbg
96: , pqh_role_extra_info rei
97: , pqh_roles rls
98: where rei.role_extra_info_id = p_role_extra_info_id
99: and rei.role_id = rls.role_id