721:
722: --
723:
724:
725: -- Validate the organisational IGS_PS_UNIT IGS_OR_INSTITUTION code is active.
726:
727:
728: FUNCTION orgp_val_ou_instn_cd(
729:
742:
743: SELECT s_institution_status
744:
745:
746: FROM IGS_OR_INSTITUTION,
747:
748:
749: IGS_OR_INST_STAT
750:
748:
749: IGS_OR_INST_STAT
750:
751:
752: WHERE IGS_OR_INSTITUTION.institution_cd = p_institution_cd
753:
754:
755: AND IGS_OR_INST_STAT.institution_status = IGS_OR_INSTITUTION.institution_status
756:
751:
752: WHERE IGS_OR_INSTITUTION.institution_cd = p_institution_cd
753:
754:
755: AND IGS_OR_INST_STAT.institution_status = IGS_OR_INSTITUTION.institution_status
756:
757:
758: AND s_institution_status <> 'ACTIVE';
759: