DBA Data[Home] [Help]

APPS.PAY_AC_TAXABILITY_CHK_ROW dependencies on PAY_US_STATES

Line 56: from pay_us_states

52:
53: cursor get_state_names
54: is
55: select state_abbrev,state_code
56: from pay_us_states
57: where state_code <= '51';
58:
59:
60: l_state_abbrev varchar2(2) := '';

Line 101: from pay_us_states

97:
98: cursor get_state_names(cp_jurisdiction_code VARCHAR2)
99: is
100: select state_abbrev
101: from pay_us_states
102: where state_code <= '51';
103:
104: cursor get_city_names(cp_state_code VARCHAR2,
105: cp_city_code VARCHAR2)