APPS.HR_AU_TAX_API dependencies on PER_BUSINESS_GROUPS

Line 1357: cursor csr_per_business_groups

1353: --
1354: l_procedure constant varchar2(60) := 'valid_business_group';
1355: l_legislation_code varchar2(30);
1356: --
1357: cursor csr_per_business_groups
1358: is
1359: select legislation_code
1360: from per_business_groups
1361: where business_group_id = p_business_group_id;

Line 1360: from per_business_groups

1356: --
1357: cursor csr_per_business_groups
1358: is
1359: select legislation_code
1360: from per_business_groups
1361: where business_group_id = p_business_group_id;
1362: --
1363: begin
1364: hr_utility.set_location(g_package||l_procedure, 1);

Line 1365: open csr_per_business_groups;

1361: where business_group_id = p_business_group_id;
1362: --
1363: begin
1364: hr_utility.set_location(g_package||l_procedure, 1);
1365: open csr_per_business_groups;
1366: fetch csr_per_business_groups
1367: into l_legislation_code;
1368: if csr_per_business_groups%notfound
1369: then

Line 1366: fetch csr_per_business_groups

1362: --
1363: begin
1364: hr_utility.set_location(g_package||l_procedure, 1);
1365: open csr_per_business_groups;
1366: fetch csr_per_business_groups
1367: into l_legislation_code;
1368: if csr_per_business_groups%notfound
1369: then
1370: close csr_per_business_groups;

Line 1368: if csr_per_business_groups%notfound

1364: hr_utility.set_location(g_package||l_procedure, 1);
1365: open csr_per_business_groups;
1366: fetch csr_per_business_groups
1367: into l_legislation_code;
1368: if csr_per_business_groups%notfound
1369: then
1370: close csr_per_business_groups;
1371: hr_utility.set_location(g_package||l_procedure, 2);
1372: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));

Line 1370: close csr_per_business_groups;

1366: fetch csr_per_business_groups
1367: into l_legislation_code;
1368: if csr_per_business_groups%notfound
1369: then
1370: close csr_per_business_groups;
1371: hr_utility.set_location(g_package||l_procedure, 2);
1372: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1373: return false;
1374: end if;

Line 1375: close csr_per_business_groups;

1371: hr_utility.set_location(g_package||l_procedure, 2);
1372: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1373: return false;
1374: end if;
1375: close csr_per_business_groups;
1376: --
1377: hr_utility.set_location(g_package||l_procedure, 10);
1378: if l_legislation_code = g_legislation_code
1379: then