APPS.OKC_ART_BLK_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 1582: FROM HR_ORGANIZATION_INFORMATION ORG

1578: l_date DATE := sysdate;
1579:
1580: CURSOR l_org_info_csr(cp_global_org_id IN NUMBER) IS
1581: SELECT ORG.organization_id, decode(ORG.org_information1, 'Y', 'ADOPTED', 'AVAILABLE')
1582: FROM HR_ORGANIZATION_INFORMATION ORG
1583: WHERE ORG.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS' AND
1584: ORG.organization_id <> cp_global_org_id;
1585:
1586: CURSOR l_non_uniq_title_csr(cp_id IN NUMBER, cp_global_org_id IN NUMBER) IS