DBA Data[Home] [Help]

APPS.PAY_PBA_BUS dependencies on PAY_BALANCE_ATTRIBUTES

Line 30: , pay_balance_attributes pba

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

Line 94: , pay_balance_attributes pba

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

Line 344: l_legislation_code pay_balance_attributes.legislation_code%type;

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: --

Line 507: l_legislation_code pay_balance_attributes.legislation_code%type;

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: --