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_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_US_COUNTIES

Line 1562: it returns County Name from paY_us_counties

1558: Purpose : This function returns the name of the jurisdiction
1559: If Jurisdiction_code is like 'XX-000-0000' then
1560: it returns State Name from py_us_states
1561: If Jurisdiction_code is like 'XX-XXX-0000' then
1562: it returns County Name from paY_us_counties
1563: If Jurisdiction_code is like 'XX-XXX-XXXX' then
1564: it returns City Name from pay_us_city_name
1565: If Jurisdiction_code is like 'XX-XXXXX' then
1566: it returns School Name from pay_us_school_dsts

Line 1586: from pay_us_counties

1582: cursor c_get_county( cp_state_code in varchar2
1583: ,cp_county_code in varchar2
1584: ) is
1585: select county_name
1586: from pay_us_counties
1587: where state_code = cp_state_code
1588: and county_code = cp_county_code;
1589:
1590: cursor c_get_city( cp_state_code in varchar2