APPS.PAY_US_MMREF_FUNCTION_PKG dependencies on PAY_US_CITY_NAMES

Line 88: FROM pay_us_city_names

84:
85: CURSOR GET_CITY_NAME(c_jurisdiction_code varchar2)
86: IS
87: SELECT city_name
88: FROM pay_us_city_names
89: WHERE state_code = substr(c_jurisdiction_code,1,2)
90: AND county_code = substr(c_jurisdiction_code,4,3)
91: AND city_code = substr(c_jurisdiction_code,8,4)
92: AND primary_flag = 'Y';

Line 108: l_city_name pay_us_city_names.city_name%TYPE;

104: AND jurisdiction_code = c_jurisdiction_code;
105:
106: l_city_value varchar2(10);
107: l_city_id varchar2(10);
108: l_city_name pay_us_city_names.city_name%TYPE;
109:
110: Begin
111:
112: hr_utility.trace('Get_City_Values');

Line 125: pay_core_utils.push_token('description','City not found in pay_us_city_names.');

121:
122: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
123: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
124: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
125: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
126: l_city_name := ' ';
127:
128: END IF;
129: