27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , pay_balance_types_tl btt
33: , pay_balance_types pbt
34: where btt.balance_type_id = p_balance_type_id
35: and btt.balance_type_id = pbt.balance_type_id
101: -- Declare cursor
102: --
103: cursor csr_leg_code is
104: select pbg.legislation_code
105: from per_business_groups_perf pbg
106: , pay_balance_types_tl btt
107: , pay_balance_types pbt
108: where btt.balance_type_id = p_balance_type_id
109: and btt.language = p_language