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

Line 2208: it returns County Name from paY_us_counties

2204: Purpose : This function returns the name of the jurisdiction
2205: If Jurisdiction_code is like 'XX-000-0000' then
2206: it returns State Name from py_us_states
2207: If Jurisdiction_code is like 'XX-XXX-0000' then
2208: it returns County Name from paY_us_counties
2209: If Jurisdiction_code is like 'XX-XXX-XXXX' then
2210: it returns City Name from pay_us_city_name
2211: If Jurisdiction_code is like 'XX-XXXXX' then
2212: it returns School Name from pay_us_school_dsts

Line 2232: from pay_us_counties

2228: cursor c_get_county( cp_state_code in varchar2
2229: ,cp_county_code in varchar2
2230: ) is
2231: select county_name
2232: from pay_us_counties
2233: where state_code = cp_state_code
2234: and county_code = cp_county_code;
2235:
2236: cursor c_get_city( cp_state_code in varchar2