APPS.PAY_BAD_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_bal_attribute_definitions bad
31: where bad.attribute_id = p_attribute_id
32: and pbg.business_group_id = bad.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_bal_attribute_definitions bad
95: where bad.attribute_id = p_attribute_id
96: and pbg.business_group_id (+) = bad.business_group_id;
97: --

Line 215: from per_business_groups

211: --
212: cursor csr_bg_leg(p_bg_id number)
213: is
214: select legislation_code
215: from per_business_groups
216: where nvl(business_group_id,-1) = nvl(p_bg_id,-1);
217: --
218: Begin
219: --

Line 385: from per_business_groups

381: --
382: cursor csr_bg_leg(p_bg_id number)
383: is
384: select legislation_code
385: from per_business_groups
386: where nvl(business_group_id,-1) = nvl(p_bg_id,-1);
387: --
388: Begin
389: --

Line 620: from per_business_groups

616: --
617: cursor get_bg_id
618: is
619: select business_group_id
620: from per_business_groups
621: where legislation_code = p_legislation_code;
622: --
623: l_proc varchar2(72) := g_package || 'chk_for_child_rows';
624: l_error EXCEPTION;