APPS.OKC_ARTICLES_GRP dependencies on DUAL

Line 52: FROM DUAL;

48: -- One Time fetch and cache the current Org.
49: CURSOR CUR_ORG_CSR IS
50: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
51: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
52: FROM DUAL;
53: */
54:
55: ---------------------------------------
56: -- PROCEDURE This API restores the variable tags from the clause text overwritten by the JAVA Parser.

Line 4023: FROM DUAL

4019: sysdate,
4020: l_User_Id,
4021: l_login_Id,
4022: sysdate
4023: FROM DUAL
4024: WHERE l_source_article_id_tbl(j) IS NOT NULL;
4025:
4026: -- Revert the target and source article ids.
4027:

Line 4053: FROM DUAL

4049: sysdate,
4050: l_User_Id,
4051: l_Login_Id,
4052: sysdate
4053: FROM DUAL
4054: WHERE l_source_article_id_tbl(j) IS NOT NULL;
4055: l_target_article_id_tbl.DELETE;
4056: l_source_article_id_tbl.DELETE;
4057: l_org_id_tbl.DELETE;