APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_OR_INST_STAT

Line 36: igs_or_inst_stat st

32:
33: CURSOR c_get_instid IS
34: SELECT ihp.oi_govt_institution_cd govt_institution_cd
35: FROM igs_pe_hz_parties ihp,
36: igs_or_inst_stat st
37: WHERE ihp.oi_institution_status = st.institution_status AND
38: st.s_institution_status= 'ACTIVE' AND
39: ihp.oi_local_institution_ind = 'Y' AND
40: ihp.inst_org_ind = 'I' AND