DBA Data[Home] [Help]

APPS.IGS_EN_GEN_012 dependencies on IGS_EN_GEN_014

Line 1672: Igs_En_Gen_014.enrs_get_within_ci(p_acad_cal_type,

1668: SELECT 'X'
1669: FROM IGS_AS_SC_ATMPT_ENR scae
1670: WHERE scae.person_id = sca.person_id AND
1671: scae.course_cd = sca.course_cd AND
1672: Igs_En_Gen_014.enrs_get_within_ci(p_acad_cal_type,
1673: p_acad_sequence_number,
1674: scae.cal_type,
1675: scae.ci_sequence_number,
1676: 'Y')

Line 2062: v_alternate_code := Igs_En_Gen_014.ENRS_GET_ACAD_ALT_CD(v_sua_rec.cal_type,

2058: v_sca_crv_rec.person_id,
2059: v_sca_crv_rec.course_cd);
2060: FETCH c_sua INTO v_sua_rec;
2061: IF (c_sua%FOUND) THEN
2062: v_alternate_code := Igs_En_Gen_014.ENRS_GET_ACAD_ALT_CD(v_sua_rec.cal_type,
2063: v_sua_rec.ci_sequence_number);
2064: v_last_teaching := v_alternate_code || '/' || v_sua_rec.alternate_code;
2065: ELSE
2066: v_last_teaching := '-';