DBA Data[Home] [Help]

APPS.PAY_PBD_BUS dependencies on PAY_BAL_ATTRIBUTE_DEFAULTS

Line 30: , pay_bal_attribute_defaults pbd

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pay_bal_attribute_defaults pbd
31: where pbd.bal_attribute_default_id = p_bal_attribute_default_id
32: and pbg.business_group_id = pbd.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pay_bal_attribute_defaults pbd

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pay_bal_attribute_defaults pbd
95: where pbd.bal_attribute_default_id = p_bal_attribute_default_id
96: and pbg.business_group_id (+) = pbd.business_group_id;
97: --
98: -- Declare local variables

Line 234: l_legislation_code pay_bal_attribute_defaults.legislation_code%type;

230: and bad.business_group_id is null
231: and bad.legislation_code is null;
232: --
233: l_exists number;
234: l_legislation_code pay_bal_attribute_defaults.legislation_code%type;
235: --
236: Begin
237: --
238: hr_utility.set_location('Entering: '||l_proc,5);

Line 397: l_legislation_code pay_bal_attribute_defaults.legislation_code%type;

393: and pbc.business_group_id is null
394: and pbc.legislation_code is null;
395: --
396: l_exists number;
397: l_legislation_code pay_bal_attribute_defaults.legislation_code%type;
398: Begin
399: --
400: hr_utility.set_location('Entering: '||l_proc,5);
401: --

Line 559: l_legislation_code pay_bal_attribute_defaults.legislation_code%type;

555: and dim.business_group_id is null
556: and dim.legislation_code is null;
557: --
558: l_exists number;
559: l_legislation_code pay_bal_attribute_defaults.legislation_code%type;
560: --
561: Begin
562: --
563: hr_utility.set_location('Entering: '||l_proc,5);