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_CITY_TAX_RULES_F

Line 1492: from PAY_US_EMP_CITY_TAX_RULES_F pcif

1488: and pcf.effective_end_date >= p_start_date
1489: and pcf.effective_start_date <= p_end_date
1490: UNION ALL
1491: select 1
1492: from PAY_US_EMP_CITY_TAX_RULES_F pcif
1493: where pcif.assignment_id = p_assignment
1494: and pcif.school_district_code is not null
1495: and pcif.effective_end_date >= p_start_date
1496: and pcif.effective_start_date <= p_end_date;

Line 1508: from PAY_US_EMP_CITY_TAX_RULES_F pcif

1504: and pcf.effective_start_date <= p_end_date
1505: and rowid <> chartorowid(p_rowid)
1506: UNION ALL
1507: select 1
1508: from PAY_US_EMP_CITY_TAX_RULES_F pcif
1509: where pcif.assignment_id = p_assignment
1510: and pcif.school_district_code is not null
1511: and pcif.effective_end_date >= p_start_date
1512: and pcif.effective_start_date <= p_end_date

Line 1789: from PAY_US_EMP_CITY_TAX_RULES_F ctr

1785: and ctr.jurisdiction_code = p_jurisdiction;
1786:
1787: cursor csr_check_city (p_jurisdiction varchar2) is
1788: select 1
1789: from PAY_US_EMP_CITY_TAX_RULES_F ctr
1790: where ctr.assignment_id = p_assignment_id
1791: and ctr.jurisdiction_code = p_jurisdiction;
1792:
1793: begin