APPS.IGS_AS_GEN_005 dependencies on IGS_EN_GEN_014

Line 572: (igs_en_gen_014.enrs_get_acad_alt_cd (suav.cal_type,

568: v_min_year VARCHAR2 (10);
569: CURSOR c_sca IS
570: SELECT MIN
571: (SUBSTR
572: (igs_en_gen_014.enrs_get_acad_alt_cd (suav.cal_type,
573: suav.ci_sequence_number
574: ),
575: 1,
576: 10

Line 615: AND igs_en_gen_014.enrs_get_within_ci (cop.cal_type,

611: AND sca.attendance_mode = cop.attendance_mode
612: AND sca.attendance_type = cop.attendance_type
613: AND cop.cal_type = ci.cal_type
614: AND cop.ci_sequence_number = ci.sequence_number
615: AND igs_en_gen_014.enrs_get_within_ci (cop.cal_type,
616: cop.ci_sequence_number,
617: suav.cal_type,
618: suav.ci_sequence_number,
619: 'Y'

Line 663: SELECT MAX (SUBSTR (igs_en_gen_014.enrs_get_acad_alt_cd (suav.cal_type, suav.ci_sequence_number), 1, 10)) acad_alternate_code

659: -- in the course.
660: DECLARE
661: v_max_year VARCHAR2 (10);
662: CURSOR c_sca IS
663: SELECT MAX (SUBSTR (igs_en_gen_014.enrs_get_acad_alt_cd (suav.cal_type, suav.ci_sequence_number), 1, 10)) acad_alternate_code
664: FROM igs_en_stdnt_ps_att sca,
665: igs_en_su_attempt suav,
666: igs_ps_ofr_pat cop,
667: igs_ca_inst ci

Line 699: AND igs_en_gen_014.enrs_get_within_ci (

695: AND sca.attendance_mode = cop.attendance_mode
696: AND sca.attendance_type = cop.attendance_type
697: AND cop.cal_type = ci.cal_type
698: AND cop.ci_sequence_number = ci.sequence_number
699: AND igs_en_gen_014.enrs_get_within_ci (
700: cop.cal_type,
701: cop.ci_sequence_number,
702: suav.cal_type,
703: suav.ci_sequence_number,