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 4190: FROM DUAL

4186: sysdate,
4187: l_User_Id,
4188: l_login_Id,
4189: sysdate
4190: FROM DUAL
4191: WHERE l_source_article_id_tbl(j) IS NOT NULL;
4192:
4193: -- Revert the target and source article ids.
4194:

Line 4220: FROM DUAL

4216: sysdate,
4217: l_User_Id,
4218: l_Login_Id,
4219: sysdate
4220: FROM DUAL
4221: WHERE l_source_article_id_tbl(j) IS NOT NULL;
4222: l_target_article_id_tbl.DELETE;
4223: l_source_article_id_tbl.DELETE;
4224: l_org_id_tbl.DELETE;