25: cursor csr_sec_grp is
26: select pbg.security_group_id,
27: pbg.legislation_code
28: from per_business_groups_perf pbg
29: , pay_user_rows_f_tl prt
30: , pay_user_rows_f pur
31: where prt.user_row_id = p_user_row_id
32: and pbg.business_group_id =pur.business_group_id;
33: --
26: select pbg.security_group_id,
27: pbg.legislation_code
28: from per_business_groups_perf pbg
29: , pay_user_rows_f_tl prt
30: , pay_user_rows_f pur
31: where prt.user_row_id = p_user_row_id
32: and pbg.business_group_id =pur.business_group_id;
33: --
34: -- Declare local variables
95: Return Varchar2 Is
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups_perf pbg
99: , pay_user_rows_f_tl prt
100: , pay_user_rows_f pur
101: where prt.user_row_id = p_user_row_id
102: and prt.language = p_language
103: and pbg.business_group_id = pur.business_group_id;
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups_perf pbg
99: , pay_user_rows_f_tl prt
100: , pay_user_rows_f pur
101: where prt.user_row_id = p_user_row_id
102: and prt.language = p_language
103: and pbg.business_group_id = pur.business_group_id;
104: --