APPS.PAY_US_MMREF_FUNCTION_PKG dependencies on PAY_US_CITY_NAMES

Line 80: FROM pay_us_city_names

76:
77: CURSOR GET_CITY_NAME(c_jurisdiction_code varchar2)
78: IS
79: SELECT city_name
80: FROM pay_us_city_names
81: WHERE state_code = substr(c_jurisdiction_code,1,2)
82: AND county_code = substr(c_jurisdiction_code,4,3)
83: AND city_code = substr(c_jurisdiction_code,8,4)
84: AND primary_flag = 'Y';

Line 100: l_city_name pay_us_city_names.city_name%TYPE;

96: AND jurisdiction_code = c_jurisdiction_code;
97:
98: l_city_value varchar2(10);
99: l_city_id varchar2(10);
100: l_city_name pay_us_city_names.city_name%TYPE;
101:
102: Begin
103:
104: hr_utility.trace('Get_City_Values');

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

113:
114: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
115: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
116: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
117: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
118: l_city_name := ' ';
119:
120: END IF;
121: