APPS.PAY_BAD_BUS dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 30: , pay_bal_attribute_definitions bad

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: --
34: -- Declare local variables

Line 94: , pay_bal_attribute_definitions bad

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: --
98: -- Declare local variables

Line 209: from pay_bal_attribute_definitions bad

205: cursor csr_attribute_name is
206: select bad.attribute_name
207: , bad.legislation_code
208: , bad.business_group_id
209: from pay_bal_attribute_definitions bad
210: where bad.attribute_name = p_attribute_name;
211: --
212: cursor csr_bg_leg(p_bg_id number)
213: is

Line 379: from pay_bal_attribute_definitions bad

375: cursor csr_user_attribute_name is
376: select bad.user_attribute_name
377: , bad.legislation_code
378: , bad.business_group_id
379: from pay_bal_attribute_definitions bad
380: where bad.user_attribute_name = p_user_attribute_name;
381: --
382: cursor csr_bg_leg(p_bg_id number)
383: is

Line 694: -- check for existing child pay_bal_attribute_definitions

690: else
691: close csr_child_attrib;
692: end if;
693: --
694: -- check for existing child pay_bal_attribute_definitions
695: --
696: open csr_child_defaults(p_attribute_id, p_business_group_id);
697: fetch csr_child_defaults into l_exists;
698: if csr_child_defaults%FOUND then