DBA Data[Home] [Help]

APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on HR_OPERATING_UNITS

Line 34: FROM hr_operating_units ou, hr_organization_information oi

30:
31: CURSOR cur_validate_ou (p_org_id IN NUMBER)
32: IS
33: SELECT 'Y'
34: FROM hr_operating_units ou, hr_organization_information oi
35: WHERE mo_global.check_access (ou.organization_id) = 'Y'
36: AND oi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
37: AND oi.organization_id = ou.organization_id
38: AND NVL (date_to, SYSDATE) >= SYSDATE

Line 839: FROM hr_operating_units ou, hr_organization_information oi

835: IS
836: CURSOR cur_val_ou (p_org_id IN NUMBER)
837: IS
838: SELECT 'X'
839: FROM hr_operating_units ou, hr_organization_information oi
840: WHERE mo_global.check_access (ou.organization_id) = 'Y'
841: AND oi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
842: AND oi.organization_id = ou.organization_id
843: AND NVL (date_to, SYSDATE) >= SYSDATE