APPS.IGS_AS_GEN_001 dependencies on IGS_EN_CAL_CONF

Line 657: v_effect_enr_strt_dt_alias igs_en_cal_conf.effect_enr_strt_dt_alias%TYPE;

653: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
654: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
655: v_acad_start_dt igs_ca_inst.start_dt%TYPE;
656: v_acad_end_dt igs_ca_inst.end_dt%TYPE;
657: v_effect_enr_strt_dt_alias igs_en_cal_conf.effect_enr_strt_dt_alias%TYPE;
658: v_effective_dt DATE;
659: v_alt_code igs_ca_inst.alternate_code%TYPE;
660: v_message_name VARCHAR2 (30);
661: cst_enrolled CONSTANT VARCHAR2 (15) := 'ENROLLED';

Line 707: FROM igs_en_cal_conf secc

703: AND ci.cal_status = cs.cal_status
704: AND cs.s_cal_status = cst_active;
705: CURSOR c_secc IS
706: SELECT secc.effect_enr_strt_dt_alias
707: FROM igs_en_cal_conf secc
708: WHERE secc.s_control_num = 1;
709: CURSOR c_daiv (
710: cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
711: cp_acad_ci_seq_no igs_ca_inst.sequence_number%TYPE,