APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_EN_GEN_014

Line 643: igs_en_gen_014.enrs_get_acad_alt_cd

639: SELECT sut.person_id, sut.course_cd, sut.unit_cd, sut.cal_type,
640: sut.ci_sequence_number, sut.uoo_id, uv.short_title, uv.title,
641: NVL (cps.achievable_credit_points, uv.achievable_credit_points),
642: uv.unit_level,
643: igs_en_gen_014.enrs_get_acad_alt_cd
644: (sut.cal_type,
645: sut.ci_sequence_number
646: ) acad_alternate_code,
647: igs_ca_gen_001.calp_get_alt_cd

Line 1259: AND igs_en_gen_014.enrs_get_within_ci (p_acad_cal_type,

1255: p_exclude_research_units_ind,
1256: p_exclude_unit_category,
1257: suav.uoo_id
1258: ) = 'Y'
1259: AND igs_en_gen_014.enrs_get_within_ci (p_acad_cal_type,
1260: p_acad_ci_sequence_number,
1261: suav.cal_type,
1262: suav.ci_sequence_number,
1263: 'Y'

Line 2073: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

2069: sca.attendance_mode = cop.attendance_mode AND
2070: sca.attendance_type = cop.attendance_type AND
2071: cop.CAL_TYPE = ci.CAL_TYPE AND
2072: cop.ci_sequence_number = ci.sequence_number AND
2073: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
2074: cop.CAL_TYPE,
2075: cop.ci_sequence_number,
2076: suav.CAL_TYPE,
2077: suav.ci_sequence_number,

Line 2168: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

2164: sca.attendance_mode = cop.attendance_mode AND
2165: sca.attendance_type = cop.attendance_type AND
2166: cop.CAL_TYPE = ci.CAL_TYPE AND
2167: cop.ci_sequence_number = ci.sequence_number AND
2168: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
2169: cop.CAL_TYPE,
2170: cop.ci_sequence_number,
2171: suav.CAL_TYPE,
2172: suav.ci_sequence_number,

Line 2221: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

2217: sua.unit_attempt_status,
2218: 'Y',
2219: -- anilk, 22-Apr-2003, Bug# 2829262
2220: sua.uoo_id) = 'FAIL')) AND
2221: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
2222: p_acad_cal_type,
2223: p_acad_ci_sequence_number,
2224: sua.CAL_TYPE,
2225: sua.ci_sequence_number,