APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on OKC_K_HEADERS_B

Line 507: SELECT 1 FROM OKC_K_HEADERS_B K

503: CURSOR l_missing_org_csr IS
504: SELECT NAME FROM HR_ALL_ORGANIZATION_UNITS ORG
505: WHERE EXISTS
506: (
507: SELECT 1 FROM OKC_K_HEADERS_B K
508: WHERE NOT EXISTS
509: (
510: SELECT
511: '1'

Line 531: FROM OKC_K_HEADERS_B K);

527: )
528: AND ORG.ORGANIZATION_ID IN
529: (SELECT /*+ PARALLEL(K) */
530: AUTHORING_ORG_ID
531: FROM OKC_K_HEADERS_B K);
532:
533: -- Cursor to fetch ALL org used in 11.5.9 okc
534: CURSOR l_k_org_csr IS
535: SELECT DISTINCT AUTHORING_ORG_ID

Line 536: FROM OKC_K_HEADERS_B;

532:
533: -- Cursor to fetch ALL org used in 11.5.9 okc
534: CURSOR l_k_org_csr IS
535: SELECT DISTINCT AUTHORING_ORG_ID
536: FROM OKC_K_HEADERS_B;
537:
538: -- Cursor to check if same article title already exists in global org for 11.5.10
539: CURSOR l_unq_csr(p_article_title IN VARCHAR2) is
540: SELECT '1' FROM OKC_ARTICLES_ALL