APPS.IGS_PR_GEN_001 dependencies on IGS_EN_SU_ATTEMPT

Line 300: FROM IGS_EN_SU_ATTEMPT sua,

296: sua.unit_attempt_status,
297: sua.discontinued_dt,
298: sca.version_number,
299: sua.uoo_id
300: FROM IGS_EN_SU_ATTEMPT sua,
301: IGS_EN_STDNT_PS_ATT sca
302: WHERE sua.person_id = p_person_id AND
303: sua.course_cd = p_course_cd AND
304: sca.person_id = sua.person_id AND

Line 313: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

309: cst_enrolled,
310: cst_completed,
311: cst_discontin);
312: CURSOR c_cat_ci_cir_cs2 (
313: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
314: cp_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
315: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
316: SELECT cir.sup_cal_type,
317: cir.sup_ci_sequence_number

Line 314: cp_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

310: cst_completed,
311: cst_discontin);
312: CURSOR c_cat_ci_cir_cs2 (
313: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
314: cp_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
315: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
316: SELECT cir.sup_cal_type,
317: cir.sup_ci_sequence_number
318: FROM IGS_CA_TYPE cat,

Line 471: FROM IGS_EN_SU_ATTEMPT sua

467: sua.ci_sequence_number,
468: sua.unit_attempt_status,
469: sua.discontinued_dt,
470: sua.uoo_id
471: FROM IGS_EN_SU_ATTEMPT sua
472: WHERE sua.person_id = p_person_id AND
473: sua.course_cd = p_course_cd AND
474: sua.cal_type = cp_sub_cal_type AND
475: sua.ci_sequence_number = cp_sub_ci_sequence_number AND