APPS.IGS_ST_GEN_003 dependencies on IGS_CA_DA_INST_V

Line 522: FROM IGS_CA_DA_INST_V daiv,

518: CURSOR c_daiv (
519: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
520: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
521: SELECT daiv.alias_val
522: FROM IGS_CA_DA_INST_V daiv,
523: IGS_GE_S_GEN_CAL_CON sgcc
524: WHERE daiv.cal_type = cp_cal_type AND
525: daiv.ci_sequence_number = cp_ci_seq_num AND
526: daiv.dt_alias = sgcc.census_dt_alias

Line 528: v_teach_census_dt IGS_CA_DA_INST_V.alias_val%TYPE;

524: WHERE daiv.cal_type = cp_cal_type AND
525: daiv.ci_sequence_number = cp_ci_seq_num AND
526: daiv.dt_alias = sgcc.census_dt_alias
527: ORDER BY daiv.alias_val ASC;
528: v_teach_census_dt IGS_CA_DA_INST_V.alias_val%TYPE;
529: v_submission_1_census_dt DATE;
530: v_submission_2_census_dt DATE;
531: v_govt_semester NUMBER;
532: v_exclusion_level VARCHAR2(15);

Line 569: -- select the alias_val from IGS_CA_DA_INST_V.

565: (v_govt_semester = 3 OR
566: v_govt_semester = 5)) OR
567: (p_submission_number = 2 AND
568: v_govt_semester = 4))) THEN
569: -- select the alias_val from IGS_CA_DA_INST_V.
570: -- select the first record only
571: OPEN c_daiv(
572: p_teach_cal_type,
573: p_teach_ci_sequence_number);