DBA Data[Home] [Help]

APPS.PAY_PCT_BUS dependencies on PAY_USER_COLUMNS

Line 29: , pay_user_columns_tl pct

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_columns_tl pct
30: , pay_user_columns puc
31: where pct.user_column_id = p_user_column_id
32: and pbg.business_group_id = puc.business_group_id;
33: --

Line 30: , pay_user_columns puc

26: select pbg.security_group_id,
27: pbg.legislation_code
28: from per_business_groups_perf pbg
29: , pay_user_columns_tl pct
30: , pay_user_columns puc
31: where pct.user_column_id = p_user_column_id
32: and pbg.business_group_id = puc.business_group_id;
33: --
34: -- Declare local variables

Line 100: , pay_user_columns_tl pct

96: --
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups_perf pbg
100: , pay_user_columns_tl pct
101: , pay_user_columns puc
102: where pct.user_column_id = p_user_column_id
103: and pct.language = p_language
104: and pbg.business_group_id = puc.business_group_id;

Line 101: , pay_user_columns puc

97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups_perf pbg
100: , pay_user_columns_tl pct
101: , pay_user_columns puc
102: where pct.user_column_id = p_user_column_id
103: and pct.language = p_language
104: and pbg.business_group_id = puc.business_group_id;
105: --