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 PAY_CA_LEGISLATION_INFO

Line 266: FROM pay_ca_legislation_info pcli

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))
270: AND p_effective_date BETWEEN pcli.start_date AND pcli.end_date;

Line 372: from pay_ca_legislation_info pcli

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
375: and p_effective_date between pcli.start_date and pcli.end_date;
376:

Line 675: from pay_ca_legislation_info pcli

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
678: and p_effective_date between pcli.start_date and pcli.end_date;
679: