[Home] [Help]
261: function get_basic_exemption(p_effective_date date,
262: p_province varchar2 DEFAULT NULL)
263: return number is
264: CURSOR sel_inf_val IS
265: SELECT fnd_number.canonical_to_number(information_value)
266: FROM pay_ca_legislation_info pcli
267: WHERE pcli.information_type = 'BASIC_EXEMPTION_AMOUNT'
268: AND ((p_province IS NULL and pcli.jurisdiction_code is null)
269: OR (pcli.jurisdiction_code = p_province))
366: if p_info_type = 'TCA' then
367:
368: if l_tax_credit_amount is null and l_basic_exemption_flag = 'Y' then
369:
370: select fnd_number.canonical_to_number(information_value)
371: into l_tax_credit_amount
372: from pay_ca_legislation_info pcli
373: where pcli.information_type = 'BASIC_EXEMPTION_AMOUNT'
374: and pcli.jurisdiction_code IS NULL
669: if p_info_type = 'TCA' then
670:
671: if l_tax_credit_amount is null and l_basic_exemption_flag = 'Y' then
672:
673: select fnd_number.canonical_to_number(information_value)
674: into l_tax_credit_amount
675: from pay_ca_legislation_info pcli
676: where pcli.information_type = 'BASIC_EXEMPTION_AMOUNT'
677: and pcli.jurisdiction_code = p_province_abbrev
1020: close csr_input_value_id;
1021: -- Modification for bug 8544619 starts here
1022: l_salary_basis := get_salary_basis(p_salary_basis_id);
1023: if l_salary_basis = 'HOURLY' and l_base_salary <> 'NOT ENTERED' then
1024: l_base_salary := fnd_number.number_to_canonical(round(fnd_number.canonical_to_number(l_base_salary),5));
1025: end if;
1026: -- Modification for bug 8544619 ends here
1027: return l_base_salary;
1028: end get_base_salary;