DBA Data[Home] [Help]

APPS.PAY_PUT_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 29: from per_business_groups_perf pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups_perf pbg
30: , pay_user_tables put
31: where put.user_table_id = p_user_table_id
32: and pbg.business_group_id = put.business_group_id;
33: --

Line 93: from per_business_groups_perf pbg

89: -- Declare cursor
90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups_perf pbg
94: , pay_user_tables put
95: where put.user_table_id = p_user_table_id
96: and pbg.business_group_id (+) = put.business_group_id;
97: --

Line 286: , per_business_groups_perf pbg

282: ,p_legislation_code in varchar2
283: ) is
284: select null
285: from pay_user_tables put
286: , per_business_groups_perf pbg
287: where upper(put.user_table_name) = p_user_table_name
288: and ((put.business_group_id = pbg.business_group_id and
289: pbg.legislation_code = p_legislation_code) or
290: (put.legislation_code = p_legislation_code) or

Line 302: , per_business_groups_perf pbg

298: ,p_business_group_id in number
299: ) is
300: select null
301: from pay_user_tables put
302: , per_business_groups_perf pbg
303: where upper(put.user_table_name) = p_user_table_name
304: and ((put.business_group_id = p_business_group_id) or
305: (pbg.business_group_id = p_business_group_id and
306: pbg.legislation_code = put.legislation_code) or