775: AND org.party_number = p_org_unit_cd
776: AND org.start_dt = p_ou_start_dt;
777:
778: v_c_ooi_sos IGS_OR_STATUS.s_org_status%TYPE;
779: v_c_ooi_lii IGS_OR_INSTITUTION.local_institution_ind%TYPE;
780: v_staff_member_ind IGS_PE_PERSON.staff_member_ind%TYPE;
781: BEGIN
782: -- Set the default message number
783: p_message_name := NULL;
802: END IF;
803: END IF;
804:
805: IF v_staff_member_ind = 'Y' THEN
806: -- Must be a local IGS_OR_INSTITUTION organisational IGS_PS_UNIT if
807: -- supervisor is a staff member.
808: IF v_c_ooi_lii ='N' THEN
809: p_message_name := 'IGS_RE_CHK_ORG_UNIT';
810: IF p_legacy <> 'Y' THEN