APPS.IGS_AD_IMP_025 dependencies on IGS_EN_SU_ATTEMPT_ALL
Line 251: FROM igs_en_su_attempt_all sa
247: CURSOR validate_cal(c_person_id igs_pe_person.person_id%TYPE,
248: c_cal_type igs_ca_inst.cal_type%TYPE,
249: c_seq_number igs_ca_inst.sequence_number%TYPE) IS
250: SELECT 'X' 251: FROM igs_en_su_attempt_all sa 252: WHERE sa.person_id = c_person_id AND
253: sa.unit_attempt_status IN ('ENROLLED','UNCONFIRM') AND
254: sa.cal_type = c_cal_type AND
255: sa.ci_sequence_number = c_seq_number;