APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on HR_ORGANIZATION_INFORMATION

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 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 512: FROM HR_ORGANIZATION_INFORMATION ORGINF

508: WHERE NOT EXISTS
509: (
510: SELECT
511: '1'
512: FROM HR_ORGANIZATION_INFORMATION ORGINF
513: WHERE ORGINF.ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
514: AND ORGINF.ORGANIZATION_ID = K.AUTHORING_ORG_ID
515: )
516: AND K.AUTHORING_ORG_ID = ORG.ORGANIZATION_ID);

Line 524: FROM HR_ORGANIZATION_INFORMATION ORGINF

520: WHERE NOT EXISTS
521: (
522: SELECT /*+ NO_UNNEST */
523: '1'
524: FROM HR_ORGANIZATION_INFORMATION ORGINF
525: WHERE ORGINF.ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
526: AND ORGINF.ORGANIZATION_ID = ORG.ORGANIZATION_ID
527: )
528: AND ORG.ORGANIZATION_ID IN

Line 1476: HR_ORGANIZATION_INFORMATION ORG

1472: INC.last_updated_by,
1473: INC.last_update_login,
1474: INC.last_update_date
1475: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,
1476: HR_ORGANIZATION_INFORMATION ORG
1477: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1478: AND SRC.orig_system_reference_id1 = INC.SAE_ID
1479: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')
1480: AND TAR.orig_system_reference_id1 = TO_CHAR(INC.SAE_ID_FOR)

Line 1538: HR_ORGANIZATION_INFORMATION ORG

1534: INC.last_updated_by,
1535: INC.last_update_login,
1536: INC.last_update_date
1537: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,
1538: HR_ORGANIZATION_INFORMATION ORG
1539: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1540: AND SRC.orig_system_reference_id1 = TO_CHAR(INC.SAE_ID)
1541: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')
1542: AND TAR.orig_system_reference_id1 = INC.SAE_ID_FOR

Line 1600: HR_ORGANIZATION_INFORMATION ORG

1596: INC.last_updated_by,
1597: INC.last_update_login,
1598: INC.last_update_date
1599: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,
1600: HR_ORGANIZATION_INFORMATION ORG
1601: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1602: AND SRC.orig_system_reference_id1 = INC.SAE_ID
1603: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')
1604: AND TAR.orig_system_reference_id1 = TO_CHAR(INC.SAE_ID_FOR)

Line 1662: HR_ORGANIZATION_INFORMATION ORG

1658: INC.last_updated_by,
1659: INC.last_update_login,
1660: INC.last_update_date
1661: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,
1662: HR_ORGANIZATION_INFORMATION ORG
1663: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1664: AND SRC.orig_system_reference_id1 = TO_CHAR(INC.SAE_ID)
1665: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')
1666: AND TAR.orig_system_reference_id1 = INC.SAE_ID_FOR

Line 1729: FROM HR_ORGANIZATION_INFORMATION

1725: sysdate,
1726: G_User_Id,
1727: G_Login_Id,
1728: sysdate
1729: FROM HR_ORGANIZATION_INFORMATION
1730: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1731: AND ORGANIZATION_ID <> G_GLOBAL_ORG_ID
1732: AND NOT EXISTS
1733: (SELECT /*+ NO_UNNEST */