APPS.IGS_AS_SU_STMPTOUT_PKG dependencies on IGS_CA_DA_INST

Line 108: CURSOR c_dt_alias_val(l_dt_alias igs_ca_da_inst.dt_alias%TYPE,

104: WHERE incomplete_grade = l_incomplete_grade
105: AND grading_schema_cd = l_grading_schema_cd
106: AND version_number = l_version_number;
107:
108: CURSOR c_dt_alias_val(l_dt_alias igs_ca_da_inst.dt_alias%TYPE,
109: l_cal_type igs_ca_da_inst.cal_type%TYPE,
110: l_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE) IS
111: SELECT max(IGS_CA_GEN_001.calp_get_alias_val(dt_alias, sequence_number, cal_type, ci_sequence_number))
112: FROM igs_ca_da_inst

Line 109: l_cal_type igs_ca_da_inst.cal_type%TYPE,

105: AND grading_schema_cd = l_grading_schema_cd
106: AND version_number = l_version_number;
107:
108: CURSOR c_dt_alias_val(l_dt_alias igs_ca_da_inst.dt_alias%TYPE,
109: l_cal_type igs_ca_da_inst.cal_type%TYPE,
110: l_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE) IS
111: SELECT max(IGS_CA_GEN_001.calp_get_alias_val(dt_alias, sequence_number, cal_type, ci_sequence_number))
112: FROM igs_ca_da_inst
113: WHERE dt_alias = l_dt_alias

Line 110: l_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE) IS

106: AND version_number = l_version_number;
107:
108: CURSOR c_dt_alias_val(l_dt_alias igs_ca_da_inst.dt_alias%TYPE,
109: l_cal_type igs_ca_da_inst.cal_type%TYPE,
110: l_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE) IS
111: SELECT max(IGS_CA_GEN_001.calp_get_alias_val(dt_alias, sequence_number, cal_type, ci_sequence_number))
112: FROM igs_ca_da_inst
113: WHERE dt_alias = l_dt_alias
114: AND cal_type = l_cal_type

Line 112: FROM igs_ca_da_inst

108: CURSOR c_dt_alias_val(l_dt_alias igs_ca_da_inst.dt_alias%TYPE,
109: l_cal_type igs_ca_da_inst.cal_type%TYPE,
110: l_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE) IS
111: SELECT max(IGS_CA_GEN_001.calp_get_alias_val(dt_alias, sequence_number, cal_type, ci_sequence_number))
112: FROM igs_ca_da_inst
113: WHERE dt_alias = l_dt_alias
114: AND cal_type = l_cal_type
115: AND ci_sequence_number = l_ci_sequence_number;
116: