APPS.OKC_ARTICLES_IMPORT_GRP dependencies on HR_ORGANIZATION_INFORMATION_V

Line 5985: FROM HR_ORGANIZATION_INFORMATION_V orgi, HR_ORGANIZATION_UNITS_V orgu

5981: AND relationship_type = cp_rel_type;
5982:
5983: CURSOR l_org_valid_csr (cp_org_id IN NUMBER) IS
5984: SELECT '1'
5985: FROM HR_ORGANIZATION_INFORMATION_V orgi, HR_ORGANIZATION_UNITS_V orgu
5986: WHERE orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
5987: AND orgi.organization_id = orgu.organization_id
5988: AND orgi.organization_id = cp_org_id;
5989: