APPS.IGS_EN_VAL_SCHO dependencies on IGS_OR_INST_STAT

Line 1726: IGS_OR_INST_STAT ist

1722: crv.version_number = sca.version_number;
1723: CURSOR c_ins IS
1724: SELECT 'x'
1725: FROM IGS_OR_INSTITUTION ins,
1726: IGS_OR_INST_STAT ist
1727: WHERE ins.local_institution_ind = 'Y' AND
1728: ins.govt_institution_cd = 2239 AND
1729: ist.institution_status = ins.institution_status AND
1730: ist.s_institution_status = 'ACTIVE';

Line 2827: IGS_OR_INST_STAT ist

2823: v_exit BOOLEAN DEFAULT FALSE;
2824: CURSOR c_ins IS
2825: SELECT ins.govt_institution_cd
2826: FROM IGS_OR_INSTITUTION ins,
2827: IGS_OR_INST_STAT ist
2828: WHERE ins.local_institution_ind = 'Y' AND
2829: ist.institution_status = ins.institution_status AND
2830: ist.s_institution_status = 'ACTIVE';
2831: CURSOR c_govt_hpo IS