APPS.IGS_EN_GEN_002 dependencies on IGS_CA_GEN_001

Line 85: ||'/'|| IGS_CA_GEN_001.calp_get_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)

81: CURSOR c_suav_details (
82: cp_person_id IGS_PE_PERSON.person_id%TYPE,
83: cp_course_cd IGS_PS_COURSE.course_cd%TYPE) IS
84: SELECT IGS_EN_GEN_014.enrs_get_acad_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
85: ||'/'|| IGS_CA_GEN_001.calp_get_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
86: FROM IGS_EN_SU_ATTEMPT SUAV,
87: IGS_CA_INST CI
88: WHERE SUAV.person_id = cp_person_id AND
89: SUAV.course_cd = cp_course_cd AND

Line 310: SELECT MIN(IGS_CA_GEN_001.calp_set_alias_value

306:
307: CURSOR c_daiv (
308: cp_acad_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
309: cp_acad_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
310: SELECT MIN(IGS_CA_GEN_001.calp_set_alias_value
311: (
312: daiv.absolute_val,
313: IGS_CA_GEN_002.cals_clc_dt_from_dai
314: (