APPS.OKS_IMPORT_TEST_INSERT dependencies on DUAL

Line 67: SELECT OKS_HEADERS_INT_BATCH_S.nextval into l_batch_id from dual;

63: BEGIN
64:
65: l_stmt_num := 10;
66:
67: SELECT OKS_HEADERS_INT_BATCH_S.nextval into l_batch_id from dual;
68:
69: l_stmt_num := 20;
70:
71: INSERT INTO OKS_HEADERS_INTERFACE

Line 290: ,(SELECT ROWNUM AS CONTRACT_NUMBER_MODIFIER FROM DUAL CONNECT BY LEVEL <=p_num_scenarios) NUM_VIEW

286: ,QP_LIST_HEADERS_VL RENPRLLST
287: ,OKC_K_GROUPS_TL GRTL
288: ,OKC_K_GRPINGS GRPNG
289: ,OKC_K_PROCESSES KPROCS
290: ,(SELECT ROWNUM AS CONTRACT_NUMBER_MODIFIER FROM DUAL CONNECT BY LEVEL <=p_num_scenarios) NUM_VIEW
291: WHERE
292: H.ID = HS.CHR_ID
293: AND H.ID = HL.ID
294: AND HL.LANGUAGE = USERENV('LANG')