26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pay_balance_attributes pba
31: where pba.balance_attribute_id = p_balance_attribute_id
32: and pbg.business_group_id = pba.business_group_id;
33: --
34: -- Declare local variables
90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pay_balance_attributes pba
95: where pba.balance_attribute_id = p_balance_attribute_id
96: and pbg.business_group_id (+) = pba.business_group_id;
97: --
98: -- Declare local variables
340: and bad.business_group_id is null
341: and bad.legislation_code is null;
342: --
343: l_exists number;
344: l_legislation_code pay_balance_attributes.legislation_code%type;
345: Begin
346: --
347: hr_utility.set_location('Entering: '||l_proc,5);
348: --
503: and pdb.business_group_id is null
504: and pdb.legislation_code is null;
505: --
506: l_exists number;
507: l_legislation_code pay_balance_attributes.legislation_code%type;
508: Begin
509: --
510: hr_utility.set_location('Entering: '||l_proc,5);
511: --