DBA Data[Home] [Help]

APPS.PAY_AMO_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_modules amo
32: where amo.module_id = p_module_id
33: and pbg.business_group_id (+) = amo.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_modules amo
104: where amo.module_id = p_module_id
105: and pbg.business_group_id (+) = amo.business_group_id;
106: --

Line 284: from per_business_groups pbg

280: cursor csr_valid_bgd_leg(
281: p_leg_code varchar2,
282: p_bg_id number) is
283: select 1
284: from per_business_groups pbg
285: where pbg.business_group_id = p_bg_id
286: and pbg.legislation_code = p_leg_code;
287: --
288: Begin