APPS.HR_AU_TAX_API dependencies on PER_BUSINESS_GROUPS

Line 1394: cursor csr_per_business_groups

1390: --
1391: l_procedure constant varchar2(60) := 'valid_business_group';
1392: l_legislation_code varchar2(30);
1393: --
1394: cursor csr_per_business_groups
1395: is
1396: select legislation_code
1397: from per_business_groups
1398: where business_group_id = p_business_group_id;

Line 1397: from per_business_groups

1393: --
1394: cursor csr_per_business_groups
1395: is
1396: select legislation_code
1397: from per_business_groups
1398: where business_group_id = p_business_group_id;
1399: --
1400: begin
1401: hr_utility.set_location(g_package||l_procedure, 1);

Line 1402: open csr_per_business_groups;

1398: where business_group_id = p_business_group_id;
1399: --
1400: begin
1401: hr_utility.set_location(g_package||l_procedure, 1);
1402: open csr_per_business_groups;
1403: fetch csr_per_business_groups
1404: into l_legislation_code;
1405: if csr_per_business_groups%notfound
1406: then

Line 1403: fetch csr_per_business_groups

1399: --
1400: begin
1401: hr_utility.set_location(g_package||l_procedure, 1);
1402: open csr_per_business_groups;
1403: fetch csr_per_business_groups
1404: into l_legislation_code;
1405: if csr_per_business_groups%notfound
1406: then
1407: close csr_per_business_groups;

Line 1405: if csr_per_business_groups%notfound

1401: hr_utility.set_location(g_package||l_procedure, 1);
1402: open csr_per_business_groups;
1403: fetch csr_per_business_groups
1404: into l_legislation_code;
1405: if csr_per_business_groups%notfound
1406: then
1407: close csr_per_business_groups;
1408: hr_utility.set_location(g_package||l_procedure, 2);
1409: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));

Line 1407: close csr_per_business_groups;

1403: fetch csr_per_business_groups
1404: into l_legislation_code;
1405: if csr_per_business_groups%notfound
1406: then
1407: close csr_per_business_groups;
1408: hr_utility.set_location(g_package||l_procedure, 2);
1409: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1410: return false;
1411: end if;

Line 1412: close csr_per_business_groups;

1408: hr_utility.set_location(g_package||l_procedure, 2);
1409: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1410: return false;
1411: end if;
1412: close csr_per_business_groups;
1413: --
1414: hr_utility.set_location(g_package||l_procedure, 10);
1415: if l_legislation_code = g_legislation_code
1416: then