9388: cursor csr_get_legc_code is
9389: select legislation_code from per_business_groups_perf
9390: where business_group_id = p_business_group_id;
9391:
9392: cursor csr_pay_legislation_rules is
9393: select legislation_code from pay_legislation_rules
9394: where legislation_code = l_legislation_code
9395: and rule_type = 'TAX_UNIT' and rule_mode = 'Y';
9396:
9389: select legislation_code from per_business_groups_perf
9390: where business_group_id = p_business_group_id;
9391:
9392: cursor csr_pay_legislation_rules is
9393: select legislation_code from pay_legislation_rules
9394: where legislation_code = l_legislation_code
9395: and rule_type = 'TAX_UNIT' and rule_mode = 'Y';
9396:
9397: begin
9408: open csr_get_legc_code;
9409: fetch csr_get_legc_code into l_legislation_code;
9410: close csr_get_legc_code;
9411:
9412: open csr_pay_legislation_rules;
9413: fetch csr_pay_legislation_rules into l_leg_code;
9414: close csr_pay_legislation_rules;
9415:
9416: if (hr_general.chk_geocodes_installed = 'Y'
9409: fetch csr_get_legc_code into l_legislation_code;
9410: close csr_get_legc_code;
9411:
9412: open csr_pay_legislation_rules;
9413: fetch csr_pay_legislation_rules into l_leg_code;
9414: close csr_pay_legislation_rules;
9415:
9416: if (hr_general.chk_geocodes_installed = 'Y'
9417: and ( ( l_legislation_code = 'CA'
9410: close csr_get_legc_code;
9411:
9412: open csr_pay_legislation_rules;
9413: fetch csr_pay_legislation_rules into l_leg_code;
9414: close csr_pay_legislation_rules;
9415:
9416: if (hr_general.chk_geocodes_installed = 'Y'
9417: and ( ( l_legislation_code = 'CA'
9418: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',