eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_EMP_TAX_INF dependencies on FND_NUMBER

Line 263: SELECT fnd_number.canonical_to_number(information_value)

259: function get_basic_exemption(p_effective_date date,
260: p_province varchar2 DEFAULT NULL)
261: return number is
262: CURSOR sel_inf_val IS
263: SELECT fnd_number.canonical_to_number(information_value)
264: FROM pay_ca_legislation_info pcli
265: WHERE pcli.information_type = 'BASIC_EXEMPTION_AMOUNT'
266: AND ((p_province IS NULL and pcli.jurisdiction_code is null)
267: OR (pcli.jurisdiction_code = p_province))

Line 368: select fnd_number.canonical_to_number(information_value)

364: if p_info_type = 'TCA' then
365:
366: if l_tax_credit_amount is null and l_basic_exemption_flag = 'Y' then
367:
368: select fnd_number.canonical_to_number(information_value)
369: into l_tax_credit_amount
370: from pay_ca_legislation_info pcli
371: where pcli.information_type = 'BASIC_EXEMPTION_AMOUNT'
372: and pcli.jurisdiction_code IS NULL

Line 626: select fnd_number.canonical_to_number(information_value)

622: if p_info_type = 'TCA' then
623:
624: if l_tax_credit_amount is null and l_basic_exemption_flag = 'Y' then
625:
626: select fnd_number.canonical_to_number(information_value)
627: into l_tax_credit_amount
628: from pay_ca_legislation_info pcli
629: where pcli.information_type = 'BASIC_EXEMPTION_AMOUNT'
630: and pcli.jurisdiction_code = p_province_abbrev