DBA Data[Home] [Help]

APPS.PAY_URT_BUS dependencies on PAY_USER_ROWS_F

Line 29: , pay_user_rows_f_tl prt

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: --

Line 30: , pay_user_rows_f pur

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

Line 99: , pay_user_rows_f_tl prt

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;

Line 100: , pay_user_rows_f pur

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: --