APPS.IGS_RE_VAL_CAH dependencies on IGS_EN_SU_ATTEMPT

Line 62: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';

58: DECLARE
59: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
60: v_daiv_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
61: cst_unconfirm CONSTANT
62: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
63: cst_duplicate CONSTANT
64: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
65: CURSOR c_ca IS
66: SELECT ca.sca_course_cd

Line 64: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';

60: v_daiv_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
61: cst_unconfirm CONSTANT
62: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
63: cst_duplicate CONSTANT
64: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
65: CURSOR c_ca IS
66: SELECT ca.sca_course_cd
67: FROM IGS_RE_CANDIDATURE ca
68: WHERE ca.person_id = p_person_id AND

Line 72: FROM IGS_EN_SU_ATTEMPT sua,

68: WHERE ca.person_id = p_person_id AND
69: ca.sequence_number = p_ca_sequence_number;
70: CURSOR c_sua_uv_daiv_sgcc IS
71: SELECT daiv.alias_val
72: FROM IGS_EN_SU_ATTEMPT sua,
73: IGS_PS_UNIT_VER uv,
74: IGS_CA_DA_INST_V daiv,
75: IGS_GE_S_GEN_CAL_CON sgcc
76: WHERE sua.person_id = p_person_id AND