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 427: pay_ca_provinces_v pcp

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

Line 437: pay_ca_provinces_v pcp

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