1523: RETURN varchar2 IS
1524:
1525: cursor csr_country_currency(cp_legislation_code in varchar2) IS
1526: select currency_code
1527: from pay_leg_setup_defaults
1528: where legislation_code = cp_legislation_code;
1529:
1530: l_proc varchar2(72) := g_package || 'get_country_currency';
1531: l_error_message varchar2(360);
1567: PROCEDURE enable_country_currency(p_legislation_code in varchar2) IS
1568:
1569: cursor csr_country_currency(cp_legislation_code in varchar2) IS
1570: select currency_code
1571: from pay_leg_setup_defaults
1572: where legislation_code = cp_legislation_code;
1573:
1574: l_proc varchar2(72) := g_package || 'enable_country_currency';
1575: l_currency_code varchar2(30);
2109: cursor csr_defaults (cp_legislation_code in varchar2) IS
2110: select legislation_code,
2111: currency_code,
2112: tax_start_date
2113: from pay_leg_setup_defaults
2114: where legislation_code = cp_legislation_code;
2115:
2116: BEGIN
2117: hr_utility.set_location('Entering:'|| l_proc, 10);