APPS.BEN_XEL_BUS dependencies on PER_BUSINESS_GROUPS

Line 22: from per_business_groups pbg

18: -- Declare cursor
19: --
20: cursor csr_sec_grp is
21: select pbg.security_group_id
22: from per_business_groups pbg
23: , ben_ext_data_elmt xel
24: where xel.ext_data_elmt_id = p_ext_data_elmt_id
25: and pbg.business_group_id = xel.business_group_id;
26: --

Line 301: -- ,per_business_groups pbg

297: --
298: cursor c1 is
299: select null
300: from ff_formulas_f ff
301: -- ,per_business_groups pbg
302: where ff.formula_id = p_data_elmt_rl
303: and ff.formula_type_id in (-413,-531,-536,-537,-538,-539,-540,-541,-542,-543,-544,-545,-546)
304: -- and pbg.business_group_id = p_business_group_id
305: -- and nvl(ff.business_group_id, p_business_group_id) =

Line 1060: l_legislation_code per_business_groups.legislation_code%TYPE;

1056: --
1057: l_proc varchar2(72) := g_package||'insert_validate';
1058:
1059: -- Added for Bug fix 2091110
1060: l_legislation_code per_business_groups.legislation_code%TYPE;
1061: --
1062: Begin
1063: hr_utility.set_location('Entering:'||l_proc, 5);
1064: --

Line 1169: l_legislation_code per_business_groups.legislation_code%TYPE;

1165: --
1166: l_proc varchar2(72) := g_package||'update_validate';
1167:
1168: -- Added for bug fix 2091110
1169: l_legislation_code per_business_groups.legislation_code%TYPE;
1170: --
1171: Begin
1172: hr_utility.set_location('Entering:'||l_proc, 5);
1173: --

Line 1279: l_legislation_code per_business_groups.legislation_code%TYPE;

1275: --
1276: l_proc varchar2(72) := g_package||'delete_validate';
1277:
1278: -- Added for Bug fix 2091110
1279: l_legislation_code per_business_groups.legislation_code%TYPE;
1280: --
1281: Begin
1282: hr_utility.set_location('Entering:'||l_proc, 5);
1283: --

Line 1324: from per_business_groups a,

1320: -- Declare cursor
1321: --
1322: cursor csr_leg_code is
1323: select a.legislation_code
1324: from per_business_groups a,
1325: ben_ext_data_elmt b
1326: where b.ext_data_elmt_id = p_ext_data_elmt_id
1327: and a.business_group_id(+) = b.business_group_id;
1328: --

Line 1331: l_legislation_code per_business_groups.legislation_code%type ;

1327: and a.business_group_id(+) = b.business_group_id;
1328: --
1329: -- Declare local variables
1330: --
1331: l_legislation_code per_business_groups.legislation_code%type ;
1332: l_proc varchar2(72) := g_package||'return_legislation_code';
1333: --
1334: begin
1335: --