DBA Data[Home] [Help]

APPS.IEX_SEND_XML_PVT dependencies on IEX_XML_QUERIES

Line 846: FROM IEX_XML_QUERIES

842: CURSOR C_GET_QUERY (IN_QUERY_ID NUMBER) IS
843: --Bug5370344. Use the New column.
844: -- SELECT upper(statement)
845: SELECT UPPER(ADDITIONAL_QUERY), UPPER(STATEMENT)
846: FROM IEX_XML_QUERIES
847: WHERE query_id = in_query_id
848: and trunc(sysdate) between trunc(nvl(start_date, sysdate)) and
849: trunc(nvl(end_date, sysdate))
850: and enabled_flag = 'Y';