30: -- Declare cursor
31: --
32: cursor csr_sec_grp is
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , pay_user_columns puc
36: where puc.user_column_id = p_user_column_id
37: and pbg.business_group_id = puc.business_group_id;
38: --
94: -- Declare cursor
95: --
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , pay_user_columns puc
100: where puc.user_column_id = p_user_column_id
101: and pbg.business_group_id (+) = puc.business_group_id;
102: --