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 1500: from PAY_US_EMP_COUNTY_TAX_RULES_F pcf

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

Line 1783: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr

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