DBA Data[Home] [Help]

APPS.IEX_PROMISE_RECON_RPT_PKG dependencies on IEX_LOOKUPS_V

Line 218: from iex_lookups_v

214: -- l_pro_status:=p_pro_status;
215: l_where:=l_where||' and ipd1.status='''||p_pro_status||'''';
216: select meaning
217: into l_pro_status
218: from iex_lookups_v
219: where lookup_code=p_pro_status
220: and lookup_type='IEX_PROMISE_STATUSES';
221: end if;
222:

Line 233: from iex_lookups_v

229: -- l_pro_state:=p_pro_state;
230: l_where:=l_where||' and ipd1.state='''||p_pro_state||'''';
231: select meaning
232: into l_pro_state
233: from iex_lookups_v
234: where lookup_code=p_pro_state
235: and lookup_type='IEX_PROMISE_STATES';
236: end if;
237: