DBA Data[Home] [Help]

APPS.OKC_XPRT_RULE_PVT dependencies on HR_OPERATING_UNITS

Line 775: FROM hr_operating_units ou, hr_organization_information oi

771:
772: CURSOR cur_val_ou (p_org_id NUMBER)
773: IS
774: SELECT 'X'
775: FROM hr_operating_units ou, hr_organization_information oi
776: WHERE mo_global.check_access (ou.organization_id) = 'Y'
777: AND oi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
778: AND oi.organization_id = ou.organization_id
779: AND NVL (date_to, SYSDATE) >= SYSDATE