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_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 1509: from PAY_US_EMP_CITY_TAX_RULES_F pcif

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

Line 1791: from PAY_US_EMP_CITY_TAX_RULES_F ctr

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