APPS.IGS_AV_GEN_001 dependencies on IGS_CA_DA_INST_V

Line 1406: FROM IGS_CA_DA_INST_V daiv,

1402: CURSOR gc_daiv(
1403: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1404: cp_ci_seq_num IGS_CA_INST.sequence_number%TYPE) IS
1405: SELECT daiv.alias_val
1406: FROM IGS_CA_DA_INST_V daiv,
1407: IGS_GE_S_GEN_CAL_CON sgcc
1408: WHERE daiv.cal_type = cp_cal_type and
1409: daiv.ci_sequence_number = cp_ci_seq_num and
1410: daiv.dt_alias = sgcc.census_dt_alias and

Line 1437: gv_census_dt IGS_CA_DA_INST_V.alias_val%TYPE;

1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1434: gv_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
1435: gv_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1436: gv_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1437: gv_census_dt IGS_CA_DA_INST_V.alias_val%TYPE;
1438: gv_message_num VARCHAR2(30);
1439: gv_message_num2 VARCHAR2(30);
1440: gv_sub_unit BOOLEAN;
1441: gv_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;

Line 1463: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

1459: DECLARE
1460: v_other_detail VARCHAR2(255);
1461: v_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1462: v_message_name VARCHAR2(30);
1463: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1464: v_admin_unit_status_str VARCHAR2(2000);
1465: BEGIN
1466: -- this module will delete student_unit_attempts
1467: -- (will need to return TRUE or FALSE)