APPS.PAY_AC_UTIL dependencies on PAY_US_COUNTIES

Line 79: it returns County Name from paY_us_counties

75: Purpose : This function returns the name of the jurisdiction
76: If Jurisdiction_code is like 'XX-000-0000' then
77: it returns State Name from py_us_states
78: If Jurisdiction_code is like 'XX-XXX-0000' then
79: it returns County Name from paY_us_counties
80: If Jurisdiction_code is like 'XX-XXX-XXXX' then
81: it returns City Name from pay_us_city_name
82: If Jurisdiction_code is like 'XX-XXXXX' then
83: it returns School Name from pay_us_school_dsts

Line 103: from pay_us_counties

99: cursor c_get_county( cp_state_code in varchar2
100: ,cp_county_code in varchar2
101: ) is
102: select county_name
103: from pay_us_counties
104: where state_code = cp_state_code
105: and county_code = cp_county_code;
106:
107: cursor c_get_city( cp_state_code in varchar2