503: select null
504: from dual
505: where exists
506: (select null
507: from hr_organization_units org,
508: hr_organization_information org2,
509: hr_org_info_types_by_class oitbc
510: where org.organization_id = p_organization_id
511: and org.organization_id = org2.organization_id
689: --
690: cursor c2 is
691: select date_from,
692: date_to
693: from hr_organization_units
694: where organization_id = p_organization_id;
695: --
696: l_c2 c2%rowtype;
697: --