APPS.IGS_RE_VAL_CAH dependencies on IGS_CA_DA_INST_V

Line 60: v_daiv_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

56: RETURN BOOLEAN AS
57: BEGIN -- resp_val_cah_census
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';

Line 74: IGS_CA_DA_INST_V daiv,

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
77: sua.course_cd = v_ca_sca_course_cd AND
78: sua.unit_attempt_status NOT IN (