DBA Data[Home] [Help]

APPS.ASO_ATP_INT dependencies on OE_LOOKUPS

Line 169: from oe_lookups l

165: where quote_header_id = p_quote_header_id;
166:
167: cursor c_request_date_type_meaning(p_lookup_code varchar2) is
168: select l.meaning
169: from oe_lookups l
170: where l.lookup_type = 'REQUEST_DATE_TYPE' and
171: l.enabled_flag = 'Y'
172: and trunc(sysdate) between nvl(start_date_active,trunc(sysdate))
173: and nvl(end_date_active,trunc(sysdate))