eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_VAL_SCA dependencies on IGS_CA_DA_INST_V

Line 239: v_research_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;

235: WHERE acaiv.person_id = p_person_id AND
236: acaiv.admission_appl_number = p_acai_admission_appl_number AND
237: acaiv.nominated_course_cd = p_acai_nominated_course_cd AND
238: acaiv.sequence_number = p_acai_sequence_number;
239: v_research_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
240: v_cal_type IGS_CA_DA_INST_V.cal_type%TYPE;
241: v_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE;
242: CURSOR c_cir_cat_daiv_srcc IS
243: SELECT daiv.alias_val,

Line 240: v_cal_type IGS_CA_DA_INST_V.cal_type%TYPE;

236: acaiv.admission_appl_number = p_acai_admission_appl_number AND
237: acaiv.nominated_course_cd = p_acai_nominated_course_cd AND
238: acaiv.sequence_number = p_acai_sequence_number;
239: v_research_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
240: v_cal_type IGS_CA_DA_INST_V.cal_type%TYPE;
241: v_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE;
242: CURSOR c_cir_cat_daiv_srcc IS
243: SELECT daiv.alias_val,
244: daiv.cal_type,

Line 241: v_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE;

237: acaiv.nominated_course_cd = p_acai_nominated_course_cd AND
238: acaiv.sequence_number = p_acai_sequence_number;
239: v_research_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
240: v_cal_type IGS_CA_DA_INST_V.cal_type%TYPE;
241: v_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE;
242: CURSOR c_cir_cat_daiv_srcc IS
243: SELECT daiv.alias_val,
244: daiv.cal_type,
245: daiv.ci_sequence_number

Line 248: IGS_CA_DA_INST_V daiv,

244: daiv.cal_type,
245: daiv.ci_sequence_number
246: FROM IGS_CA_INST_REL cir,
247: IGS_CA_TYPE cat,
248: IGS_CA_DA_INST_V daiv,
249: IGS_RE_S_RES_CAL_CON srcc
250: WHERE cir.sub_cal_type = v_adm_cal_type AND
251: cir.sub_ci_sequence_number = v_adm_ci_sequence_number AND
252: cir.sup_cal_type = cat.cal_type AND

Line 264: IGS_CA_DA_INST_V daiv,

260: CURSOR c_cir_cat_daiv_sgcc IS
261: SELECT 'x'
262: FROM IGS_CA_INST_REL cir,
263: IGS_CA_TYPE cat,
264: IGS_CA_DA_INST_V daiv,
265: IGS_GE_S_GEN_CAL_CON sgcc
266: WHERE cir.sub_cal_type = v_adm_cal_type AND
267: cir.sub_ci_sequence_number = v_adm_ci_sequence_number AND
268: cir.sup_cal_type = cat.cal_type AND

Line 2138: v_course_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;

2134: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
2135: cst_sca CONSTANT VARCHAR2(4) := 'SCA';
2136: -- Variables
2137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2138: v_course_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
2139: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
2140: v_candidature_exists_ind VARCHAR2(1);
2141: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
2142: v_message_name varchar2(30);

Line 2145: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

2141: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
2142: v_message_name varchar2(30);
2143: -- Temporary variables
2144: v_dt_diff NUMBER;
2145: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
2146: v_only_one_rec_found BOOLEAN := FALSE;
2147: v_commencement_dt_validated BOOLEAN;
2148: CURSOR c_sct_sca_crv IS
2149: SELECT sca.commencement_dt

Line 2193: FROM IGS_CA_DA_INST_V daiv,

2189: FROM igs_pe_person_base_v
2190: WHERE person_id = p_person_id;
2191: CURSOR c_daiv_secc IS
2192: SELECT daiv.alias_val
2193: FROM IGS_CA_DA_INST_V daiv,
2194: IGS_EN_CAL_CONF secc
2195: WHERE daiv.cal_type = p_acad_cal_type AND
2196: daiv.ci_sequence_number = p_acad_ci_sequence_number AND
2197: secc.commencement_dt_alias = daiv.dt_alias AND