DBA Data[Home] [Help]

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.