APPS.IGS_PR_CLASS_RANK dependencies on IGS_EN_SU_ATTEMPT

Line 868: FROM igs_en_su_attempt sua, igs_en_sca_v sca

864: sca.cal_type IN ' || l_acad_cal || ' AND
865: (sca.person_id, sca.course_cd) IN
866: (
867: SELECT sca.person_id, sca.course_cd
868: FROM igs_en_su_attempt sua, igs_en_sca_v sca
869: WHERE sua.person_id = sca.person_id
870: AND sua.course_cd = sca.course_cd
871: AND unit_attempt_status = ''COMPLETED''
872: AND ( sua.cal_type , sua.ci_sequence_number ) IN

Line 1054: FROM igs_en_su_attempt sua, igs_en_sca_v sca

1050: AND
1051: (sca.person_id, sca.course_cd) IN
1052: (
1053: SELECT sca.person_id, sca.course_cd
1054: FROM igs_en_su_attempt sua, igs_en_sca_v sca
1055: WHERE sua.person_id = sca.person_id
1056: AND sua.course_cd = sca.course_cd
1057: AND unit_attempt_status = ''COMPLETED''
1058: AND ( sua.cal_type , sua.ci_sequence_number ) IN

Line 1281: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

1277: FUNCTION rulp_val_senna_res (
1278: p_person_id IN igs_en_sca_v.person_id%TYPE,
1279: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,
1280: p_course_version IN igs_en_sca_v.version_number%TYPE,
1281: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1282: p_unit_version IN igs_en_su_attempt.version_number%TYPE,
1283: p_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1284: p_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
1285: p_rule_number IN igs_ru_call_v.rul_sequence_number%TYPE) RETURN VARCHAR2 IS

Line 1282: p_unit_version IN igs_en_su_attempt.version_number%TYPE,

1278: p_person_id IN igs_en_sca_v.person_id%TYPE,
1279: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,
1280: p_course_version IN igs_en_sca_v.version_number%TYPE,
1281: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1282: p_unit_version IN igs_en_su_attempt.version_number%TYPE,
1283: p_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1284: p_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
1285: p_rule_number IN igs_ru_call_v.rul_sequence_number%TYPE) RETURN VARCHAR2 IS
1286:

Line 1283: p_cal_type IN igs_en_su_attempt.cal_type%TYPE,

1279: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,
1280: p_course_version IN igs_en_sca_v.version_number%TYPE,
1281: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1282: p_unit_version IN igs_en_su_attempt.version_number%TYPE,
1283: p_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1284: p_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
1285: p_rule_number IN igs_ru_call_v.rul_sequence_number%TYPE) RETURN VARCHAR2 IS
1286:
1287: /****************************************************************************************************************

Line 1284: p_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

1280: p_course_version IN igs_en_sca_v.version_number%TYPE,
1281: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1282: p_unit_version IN igs_en_su_attempt.version_number%TYPE,
1283: p_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1284: p_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
1285: p_rule_number IN igs_ru_call_v.rul_sequence_number%TYPE) RETURN VARCHAR2 IS
1286:
1287: /****************************************************************************************************************
1288: || Created By : DDEY