DBA Data[Home] [Help]

APPS.IGS_GE_GEN_001 dependencies on IGS_CA_INST

Line 1083: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,

1079: -- This module gets the IGS_PS_COURSE completion cutoff date.
1080: DECLARE
1081: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1082: CURSOR c_daiv_sgcc (
1083: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
1084: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1085: SELECT daiv.alias_val
1086: FROM IGS_CA_DA_INST_V daiv,
1087: IGS_GE_S_GEN_CAL_CON sgcc

Line 1084: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1080: DECLARE
1081: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1082: CURSOR c_daiv_sgcc (
1083: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
1084: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1085: SELECT daiv.alias_val
1086: FROM IGS_CA_DA_INST_V daiv,
1087: IGS_GE_S_GEN_CAL_CON sgcc
1088: WHERE daiv.cal_type = cp_acad_cal_type AND