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_PROVINCES_V

Line 425: pay_ca_provinces_v pcp

421: CURSOR csr_get_default_province IS
422: select pcp.province_abbrev, '70-'||pcp.province_code||'-0000' geocode
423: from per_assignments_f paf,
424: hr_locations hl,
425: pay_ca_provinces_v pcp
426: where paf.assignment_id = p_assignment_id
427: and p_effective_date between paf.effective_start_date
428: and paf.effective_end_date
429: and paf.location_id = hl.location_id

Line 435: pay_ca_provinces_v pcp

431:
432: CURSOR csr_get_override_province IS
433: select pcp.province_abbrev, '70-'||pcp.province_code||'-0000' geocode
434: from pay_ca_emp_fed_tax_info_f pf,
435: pay_ca_provinces_v pcp
436: where p_effective_date between pf.effective_start_date
437: and pf.effective_end_date
438: and pf.employment_province = pcp.province_abbrev
439: and pf.assignment_id = p_assignment_id;