26: -- Declare cursor
27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , pay_element_types_f_tl ett
32: , pay_element_types_f etp
33: where ett.element_type_id = p_element_type_id
34: and pbg.business_group_id = etp.business_group_id
94: -- Declare cursor
95: --
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , pay_element_types_f_tl ett
100: , pay_element_types_f etp
101: where ett.element_type_id = p_element_type_id
102: and pbg.business_group_id = etp.business_group_id