APPS.IGS_RE_VAL_RSUP dependencies on IGS_OR_STATUS

Line 768: FROM igs_or_status os,

764: DECLARE
765: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
766: CURSOR c_ou_os_ins IS
767: SELECT os.s_org_status, ins.oi_local_institution_ind
768: FROM igs_or_status os,
769: igs_or_inst_org_base_v org,
770: igs_or_inst_org_base_v ins
771: WHERE org.inst_org_ind = 'O'
772: AND org.org_status = os.org_status

Line 778: v_c_ooi_sos IGS_OR_STATUS.s_org_status%TYPE;

774: AND ins.party_number = org.ou_institution_cd
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