APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_CA_STAT

Line 138: igs_ca_stat cstat

134: -- Cursor to validate Calendars
135: CURSOR c_cal(p_cal_type IGS_CA_INST.cal_type%TYPE, p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
136: SELECT cal.cal_type, cal.sequence_number,cal.description
137: FROM IGS_CA_INST cal,
138: igs_ca_stat cstat
139: WHERE cal.cal_type = p_cal_type AND
140: cal.sequence_number = p_sequence_number AND
141: end_dt > sysdate AND
142: cstat.cal_status = cal.cal_status AND

Line 154: igs_ca_stat cstat

150: igs_ca_inst_rel cir,
151: igs_ca_inst ci2,
152: igs_ca_type cat1,
153: igs_ca_type cat2,
154: igs_ca_stat cstat
155: WHERE
156: ci1.CAL_TYPE = p_adm_cal_type AND
157: ci1.sequence_number = p_adm_sequence_number AND
158: ci2.CAL_TYPE = p_acad_cal_type AND