APPS.OKC_ART_BLK_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 1583: FROM HR_ORGANIZATION_INFORMATION ORG

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