DBA Data[Home] [Help]

APPS.PAY_PBC_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pay_balance_categories_f pbc
31: where pbc.balance_category_id = p_balance_category_id
32: and pbg.business_group_id = pbc.business_group_id;
33: --

Line 93: from per_business_groups pbg

89: -- Declare cursor
90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pay_balance_categories_f pbc
95: where pbc.balance_category_id = p_balance_category_id
96: and pbg.business_group_id (+) = pbc.business_group_id;
97: --

Line 722: from per_business_groups

718: --
719: cursor get_bg_id
720: is
721: select business_group_id
722: from per_business_groups
723: where legislation_code = p_legislation_code;
724: --
725: l_proc varchar2(72) := g_package || 'chk_for_child_rows';
726: l_error EXCEPTION;