APPS.CSI_II_RELATIONSHIPS_PVT dependencies on DUAL

Line 120: from dual ;

116: END IF;
117:
118: select to_char(sysdate,'YY-MON-DD HH:MI:SS')
119: into l_start_time
120: from dual ;
121:
122: -- Initialize the given instance to non-visited table
123:
124: l_non_visited_tbl(1).instance_id := p_instance_id ;

Line 231: from dual ;

227: END LOOP ; -- l_non_visited_tbl.COUNT > 0
228:
229: select to_char(sysdate,'YY-MON-DD HH:MI:SS')
230: into l_end_time
231: from dual ;
232:
233: EXCEPTION
234: WHEN fnd_api.g_exc_unexpected_error THEN
235: --ROLLBACK TO get_cylic_relationships_pvt;

Line 310: FROM dual;

306: BEGIN
307: i:= 0;
308: SELECT SYSDATE
309: INTO l_sysdate
310: FROM dual;
311: --
312: -- srramakr Bug # 2882876
313: IF p_time_stamp = FND_API.G_MISS_DATE THEN
314: l_time_stamp := null;

Line 424: FROM DUAL;

420:
421: BEGIN
422: SELECT SYSDATE
423: INTO l_sysdate
424: FROM DUAL;
425: --
426: -- srramakr Bug # 2882876
427: IF p_time_stamp = FND_API.G_MISS_DATE THEN
428: l_time_stamp := null;

Line 651: FROM dual;

647: )
648: IS
649: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
650: SELECT instr(p_rec_item, '%', 1, 1)
651: FROM dual;
652: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
653: SELECT instr(p_rec_item, '_', 1, 1)
654: FROM dual;
655:

Line 654: FROM dual;

650: SELECT instr(p_rec_item, '%', 1, 1)
651: FROM dual;
652: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
653: SELECT instr(p_rec_item, '_', 1, 1)
654: FROM dual;
655:
656: -- return values from cursors
657: str_csr1 NUMBER;
658: str_csr2 NUMBER;

Line 1388: from dual;

1384: COMP_EXCEP EXCEPTION;
1385: BEGIN
1386: select sysdate
1387: into l_sysdate
1388: from dual;
1389: --
1390: IF p_time_stamp IS NOT NULL THEN
1391: l_active_instances_only := FND_API.G_FALSE;
1392: l_active_relationship_only := FND_API.G_FALSE;