APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_EN_CAL_CONF

Line 387: l_begin_trans_dt_alias IGS_EN_CAL_CONF.BEGIN_TRANS_DT_ALIAS%TYPE;

383: when source key program = 'Y' else set destination program key program = Y
384:
385: */
386:
387: l_begin_trans_dt_alias IGS_EN_CAL_CONF.BEGIN_TRANS_DT_ALIAS%TYPE;
388: l_begin_trans_dt_alias_val DATE;
389: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
390: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
391: CURSOR c_get_key_val_frm_src_prg IS

Line 398: FROM IGS_EN_CAL_CONF

394: WHERE person_id = p_person_id AND
395: course_cd = p_src_program_cd;
396: CURSOR c_get_begin_trans_dt_alias IS
397: SELECT begin_trans_dt_alias
398: FROM IGS_EN_CAL_CONF
399: WHERE s_control_num = 1;
400: CURSOR c_get_begin_trans_dt_alias_val(c_begin_dt_alias IGS_EN_CAL_CONF.BEGIN_TRANS_DT_ALIAS%TYPE) IS
401: SELECT ALIAS_VAL
402: FROM IGS_CA_DA_INST_V

Line 400: CURSOR c_get_begin_trans_dt_alias_val(c_begin_dt_alias IGS_EN_CAL_CONF.BEGIN_TRANS_DT_ALIAS%TYPE) IS

396: CURSOR c_get_begin_trans_dt_alias IS
397: SELECT begin_trans_dt_alias
398: FROM IGS_EN_CAL_CONF
399: WHERE s_control_num = 1;
400: CURSOR c_get_begin_trans_dt_alias_val(c_begin_dt_alias IGS_EN_CAL_CONF.BEGIN_TRANS_DT_ALIAS%TYPE) IS
401: SELECT ALIAS_VAL
402: FROM IGS_CA_DA_INST_V
403: WHERE dt_alias = c_begin_dt_alias AND
404: cal_type = p_term_cal_type AND