APPS.IGS_EN_GEN_005 dependencies on IGS_EN_SU_ATTEMPT

Line 152: IGS_EN_SU_ATTEMPT sua,

148: sua.ci_sequence_number,
149: ci.cal_type parent_cal_type,
150: ci.sequence_number parent_sequence_number
151: FROM IGS_CA_INST aci,
152: IGS_EN_SU_ATTEMPT sua,
153: IGS_CA_INST_REL cir,
154: IGS_CA_INST ci
155: WHERE
156: aci.cal_type = p_acad_cal_type AND

Line 223: FROM IGS_EN_SU_ATTEMPT sua

219: posp.acad_period_num < p_acad_period_num;
220: CURSOR c_sua (cp_posu_unit_cd IGS_PS_PAT_STUDY_UNT.unit_cd%TYPE,
221: cp_posp_teach_cal_type IGS_PS_PAT_STUDY_PRD.teach_cal_type%TYPE) IS
222: SELECT 'X'
223: FROM IGS_EN_SU_ATTEMPT sua
224: WHERE sua.person_id = p_person_id AND
225: sua.course_cd = p_course_cd AND
226: sua.unit_cd = cp_posu_unit_cd AND
227: sua.cal_type = cp_posp_teach_cal_type AND

Line 634: FROM IGS_EN_SU_ATTEMPT sua_v,

630: DECLARE
631: -- modified cursor for performance bug 3687265
632: CURSOR c_get_acad_alt_cd IS
633: SELECT SUBSTR(IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua_v.cal_type,sua_v.ci_sequence_number),1,10)
634: FROM IGS_EN_SU_ATTEMPT sua_v,
635: IGS_CA_INST ci
636: WHERE sua_v.person_id = p_person_id AND
637: sua_v.enrolled_dt IS NOT NULL AND
638: sua_v.cal_type = ci.cal_type AND

Line 682: FROM IGS_EN_SU_ATTEMPT sua_v,

678: DECLARE
679: --modified cursor for performance bug 3687150
680: CURSOR c_get_acad_alt_cd IS
681: SELECT SUBSTR(IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua_v.cal_type,sua_v.ci_sequence_number),1,10)
682: FROM IGS_EN_SU_ATTEMPT sua_v,
683: IGS_CA_INST ci
684: WHERE sua_v.person_id = p_person_id AND
685: sua_v.enrolled_dt IS NOT NULL AND
686: sua_v.cal_type = ci.cal_type AND