APPS.HR_ORGANIZATION_INTERNAL dependencies on HR_OPERATING_UNITS
Line 74: select 'Y' from HR_OPERATING_UNITS
70:
71:
72: --Cursor to check valid operating unit id is passed or not
73: cursor is_valid_ou_id is 74: select 'Y' from HR_OPERATING_UNITS 75: where trunc(sysdate) between trunc(date_from) and nvl(trunc(date_to), trunc(sysdate))
76: and organization_id = p_operating_unit;
77:
78: -- Cursor to check valid organization name is passed or not.