425: SELECT
426: A.REQUEST_ID
427: INTO L_SET_REQUEST_ID
428: FROM
429: FND_CONCURRENT_REQUESTS A
430: WHERE A.PARENT_REQUEST_ID = (
431: SELECT
432: B.REQUEST_ID
433: FROM
430: WHERE A.PARENT_REQUEST_ID = (
431: SELECT
432: B.REQUEST_ID
433: FROM
434: FND_CONCURRENT_REQUESTS B
435: WHERE B.PARENT_REQUEST_ID = (
436: SELECT
437: C.PARENT_REQUEST_ID
438: FROM
435: WHERE B.PARENT_REQUEST_ID = (
436: SELECT
437: C.PARENT_REQUEST_ID
438: FROM
439: FND_CONCURRENT_REQUESTS C
440: WHERE C.ROWID <> B.ROWID
441: AND C.REQUEST_ID = (
442: SELECT
443: D.PARENT_REQUEST_ID
441: AND C.REQUEST_ID = (
442: SELECT
443: D.PARENT_REQUEST_ID
444: FROM
445: FND_CONCURRENT_REQUESTS D
446: WHERE D.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID ) ) );
447: EXCEPTION
448: WHEN OTHERS THEN
449: RAISE_ORA_ERR;