DBA Data[Home] [Help]

APPS.PAY_AC_UTIL dependencies on PAY_US_STATES

Line 96: from pay_us_states

92: IS
93:
94: cursor c_get_state(cp_state_code in varchar2) is
95: select state_abbrev
96: from pay_us_states
97: where state_code = cp_state_code;
98:
99: cursor c_get_county( cp_state_code in varchar2
100: ,cp_county_code in varchar2

Line 164: from pay_us_states

160: IS
161:
162: cursor c_get_state(cp_state_code in varchar2) is
163: select state_abbrev
164: from pay_us_states
165: where state_code = cp_state_code;
166:
167: lv_state_code VARCHAR2(2) := substr(p_jurisdiction_code,1,2);
168: lv_state_abbrev VARCHAR2(2):= null;