APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_EN_SUSA_CC

Line 4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,

4557: FROM IGS_PS_FLD_OF_STUDY PFS
4558: WHERE field_of_study = p_subject;
4559:
4560: -- Cost Centers at Student Unit Set Attempt Level
4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,
4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'

Line 4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,

4558: WHERE field_of_study = p_subject;
4559:
4560: -- Cost Centers at Student Unit Set Attempt Level
4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,
4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'
4566: FROM IGS_HE_EN_SUSA_CC

Line 4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,

4559:
4560: -- Cost Centers at Student Unit Set Attempt Level
4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,
4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'
4566: FROM IGS_HE_EN_SUSA_CC
4567: WHERE person_id = cp_person_id

Line 4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS

4560: -- Cost Centers at Student Unit Set Attempt Level
4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,
4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'
4566: FROM IGS_HE_EN_SUSA_CC
4567: WHERE person_id = cp_person_id
4568: AND course_cd = cp_course_cd

Line 4566: FROM IGS_HE_EN_SUSA_CC

4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'
4566: FROM IGS_HE_EN_SUSA_CC
4567: WHERE person_id = cp_person_id
4568: AND course_cd = cp_course_cd
4569: AND unit_set_cd = cp_unit_set_cd
4570: AND sequence_number = cp_sequence_number;

Line 4727: FROM igs_he_en_susa_cc

4723: CLOSE susa_cc_dtls_cur;
4724:
4725: OPEN c_cc FOR
4726: SELECT cost_centre, subject, proportion
4727: FROM igs_he_en_susa_cc
4728: WHERE person_id = p_person_id
4729: AND course_cd = p_course_cd
4730: AND unit_set_cd = p_unit_set_cd
4731: AND sequence_number = p_sequence_number