APPS.IEM_MAILITEM_PUB dependencies on DUAL

Line 1181: from dual;

1177: SAVEPOINT getemailheaders_pvt;
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1179: select decode(p_sort_order,0,'ASC','DESC')
1180: into l_sort_order
1181: from dual;
1182: IF p_sort_by = FND_API.G_MISS_CHAR OR p_sort_by='D' THEN
1183: l_order_by:=' Order BY to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'') '||l_sort_order;
1184: ELSIF p_sort_by='S' THEN
1185: l_order_by:='ORDER BY a.subject '||l_sort_order||',to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'') '||l_sort_order;