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.

[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_VAL dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 1485: from PAY_US_EMP_COUNTY_TAX_RULES_F pcf

1481: l_code number;
1482:
1483: cursor chk_ins_sd is
1484: select 1
1485: from PAY_US_EMP_COUNTY_TAX_RULES_F pcf
1486: where pcf.assignment_id = p_assignment
1487: and pcf.school_district_code is not null
1488: and pcf.effective_end_date >= p_start_date
1489: and pcf.effective_start_date <= p_end_date

Line 1501: from PAY_US_EMP_COUNTY_TAX_RULES_F pcf

1497: and pcif.state_code <> '39';
1498:
1499: cursor chk_upd_sd is
1500: select 1
1501: from PAY_US_EMP_COUNTY_TAX_RULES_F pcf
1502: where pcf.assignment_id = p_assignment
1503: and pcf.school_district_code is not null
1504: and pcf.effective_end_date >= p_start_date
1505: and pcf.effective_start_date <= p_end_date

Line 1785: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr

1781: and str.jurisdiction_code = p_jurisdiction;
1782:
1783: cursor csr_check_county (p_jurisdiction varchar2) is
1784: select 1
1785: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr
1786: where ctr.assignment_id = p_assignment_id
1787: and ctr.jurisdiction_code = p_jurisdiction;
1788:
1789: cursor csr_check_city (p_jurisdiction varchar2) is