APPS.IGS_PR_VAL_SPO dependencies on IGS_CA_DA_INST_V

Line 504: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
501: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
502: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
503: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
504: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
505: v_outcome_check_type VARCHAR2(10);
506: CURSOR c_sca IS
507: SELECT sca.version_number
508: FROM IGS_EN_STDNT_PS_ATT sca

Line 514: FROM IGS_CA_DA_INST_V daiv

510: sca.course_cd = p_course_cd;
511: CURSOR c_daiv
512: (cp_shw_cse_ctoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE) IS
513: SELECT MAX(daiv.alias_val)
514: FROM IGS_CA_DA_INST_V daiv
515: WHERE daiv.dt_alias = cp_shw_cse_ctoff_dt_alias AND
516: daiv.cal_type = p_prg_cal_type AND
517: daiv.ci_sequence_number = p_prg_ci_sequence_number;
518: BEGIN

Line 825: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
822: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
823: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
824: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
825: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
826: v_outcome_check_type VARCHAR2(10);
827: CURSOR c_sca IS
828: SELECT sca.version_number
829: FROM IGS_EN_STDNT_PS_ATT sca

Line 834: FROM IGS_CA_DA_INST_V daiv

830: WHERE sca.person_id = p_person_id AND
831: sca.course_cd = p_course_cd;
832: CURSOR c_daiv (cp_apl_ctoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE) IS
833: SELECT MAX(daiv.alias_val)
834: FROM IGS_CA_DA_INST_V daiv
835: WHERE daiv.dt_alias = cp_apl_ctoff_dt_alias AND
836: daiv.cal_type = p_prg_cal_type AND
837: daiv.ci_sequence_number = p_prg_ci_sequence_number;
838: BEGIN