DBA Data[Home] [Help]

APPS.PAY_APR_BUS dependencies on PER_BUSINESS_GROUPS

Line 30: from per_business_groups_perf pbg

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pay_au_processes apr
32: where apr.process_id = p_process_id
33: and pbg.business_group_id (+) = apr.business_group_id;
34: --

Line 102: from per_business_groups_perf pbg

98: -- Declare cursor
99: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups_perf pbg
103: , pay_au_processes apr
104: where apr.process_id = p_process_id
105: and pbg.business_group_id (+) = apr.business_group_id;
106: --

Line 264: from per_business_groups pbg

260: cursor csr_valid_bgd_leg(
261: p_leg_code varchar2,
262: p_bg_id number) is
263: select 1
264: from per_business_groups pbg
265: where pbg.business_group_id = p_bg_id
266: and pbg.legislation_code = p_leg_code;
267: --
268: Begin