APPS.INV_STATUS_PKG dependencies on DUAL

Line 11: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;

7: l_msg VARCHAR2(5100);
8: l_ts VARCHAR2(30);
9: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10: BEGIN
11: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
12:
13: l_msg:=l_ts||' '||msg;
14:
15: IF (l_debug = 1) THEN

Line 1206: From dual;

1202: if NVL(l_old_status_id, -9999) <> p_onhand_status_id then
1203: --Bug#11826279
1204: /*Select mtl_onhand_status_group_s.nextval
1205: Into l_status_group_id
1206: From dual;
1207:
1208: l_status_rec.group_id := l_status_group_id; */
1209:
1210: l_status_rec.group_id := p_group_id ; --ERES Deferred

Line 1235: From dual;

1231: if (l_count = 0) then
1232: --Bug#11826279
1233: /*Select mtl_onhand_status_group_s.nextval
1234: Into l_status_group_id
1235: From dual;
1236:
1237: l_status_rec.group_id := l_status_group_id; */
1238: l_status_rec.group_id := p_group_id ; --ERES Deferred
1239: l_status_rec.pending_status := p_pending_status; --ERES Deferred