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:
1183: -- Fix for bug 10417273 - sanjana rao,mandating to_date function to use English while
1184: -- converting the date, in order by and delect clause
1185: IF p_sort_by = FND_API.G_MISS_CHAR OR p_sort_by='D' THEN

Line 1333: from dual;

1329:
1330:
1331: select decode(p_sort_order,0,'ASC','DESC')
1332: into l_sort_order
1333: from dual;
1334:
1335: IF p_sort_by = FND_API.G_MISS_CHAR OR p_sort_by='D' THEN
1336: l_order_by:=' Order BY to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'',''NLS_DATE_LANGUAGE=ENGLISH'') '||l_sort_order;
1337: ELSIF p_sort_by='S' THEN