APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 261: FROM HR_ORGANIZATION_INFORMATION INF, HR_ALL_ORGANIZATION_UNITS UNIT

257: -- Cursor to fetch current Org info
258:
259: CURSOR l_current_org_info_csr IS
260: SELECT INF.ORGANIZATION_ID, UNIT.NAME
261: FROM HR_ORGANIZATION_INFORMATION INF, HR_ALL_ORGANIZATION_UNITS UNIT
262: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
263: AND INF.ORGANIZATION_ID = UNIT.ORGANIZATION_ID
264: AND INF.ORGANIZATION_ID = G_CURRENT_ORG_ID;
265:

Line 267: l_org_name HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;

263: AND INF.ORGANIZATION_ID = UNIT.ORGANIZATION_ID
264: AND INF.ORGANIZATION_ID = G_CURRENT_ORG_ID;
265:
266: l_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE;
267: l_org_name HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
268: l_row_notfound BOOLEAN:=FALSE;
269:
270: BEGIN
271:

Line 497: FROM HR_ORGANIZATION_INFORMATION INF, HR_ALL_ORGANIZATION_UNITS UNIT

493: -- Cursor to fetch ALL Orgs that are set up for Articles
494:
495: CURSOR l_org_info_csr IS
496: SELECT INF.ORGANIZATION_ID, UNIT.NAME
497: FROM HR_ORGANIZATION_INFORMATION INF, HR_ALL_ORGANIZATION_UNITS UNIT
498: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
499: AND INF.ORGANIZATION_ID = UNIT.ORGANIZATION_ID;
500:
501: -- Cursor to check setup: ALL Orgs used in contracts must be set up for Articles

Line 504: SELECT NAME FROM HR_ALL_ORGANIZATION_UNITS ORG

500:
501: -- Cursor to check setup: ALL Orgs used in contracts must be set up for Articles
502: /*
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

Line 519: SELECT NAME FROM HR_ALL_ORGANIZATION_UNITS ORG

515: )
516: AND K.AUTHORING_ORG_ID = ORG.ORGANIZATION_ID);
517: */
518: CURSOR l_missing_org_csr IS
519: SELECT NAME FROM HR_ALL_ORGANIZATION_UNITS ORG
520: WHERE NOT EXISTS
521: (
522: SELECT /*+ NO_UNNEST */
523: '1'