DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 733: FROM HR_ALL_ORGANIZATION_UNITS

729: l_count NUMBER;
730:
731: CURSOR c_org_info_csr IS
732: SELECT ORGANIZATION_ID
733: FROM HR_ALL_ORGANIZATION_UNITS
734: WHERE UPPER(NAME) = UPPER(p_org_name)
735: AND mo_global.check_access(ORGANIZATION_ID) = 'Y';
736:
737: CURSOR c_contract_type_valid_csr IS