APPS.IGS_RE_GEN_002 dependencies on IGS_RE_S_RES_CAL_CON

Line 884: v_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;

880: -- set up for the nominated teaching period to be a research teaching
881: -- period.
882: DECLARE
883: E_NO_RESEARCH_CAL_CONFIG EXCEPTION;
884: v_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;
885: v_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE;
886: v_start_alias_val IGS_CA_DA_INST.absolute_val%TYPE DEFAULT NULL;
887: v_end_alias_val IGS_CA_DA_INST.absolute_val%TYPE DEFAULT NULL;
888: CURSOR c_srcc IS

Line 885: v_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE;

881: -- period.
882: DECLARE
883: E_NO_RESEARCH_CAL_CONFIG EXCEPTION;
884: v_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;
885: v_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE;
886: v_start_alias_val IGS_CA_DA_INST.absolute_val%TYPE DEFAULT NULL;
887: v_end_alias_val IGS_CA_DA_INST.absolute_val%TYPE DEFAULT NULL;
888: CURSOR c_srcc IS
889: SELECT srcc.effective_strt_dt_alias,

Line 891: FROM IGS_RE_S_RES_CAL_CON srcc

887: v_end_alias_val IGS_CA_DA_INST.absolute_val%TYPE DEFAULT NULL;
888: CURSOR c_srcc IS
889: SELECT srcc.effective_strt_dt_alias,
890: srcc.effective_end_dt_alias
891: FROM IGS_RE_S_RES_CAL_CON srcc
892: WHERE srcc.s_control_num = 1;
893: FUNCTION resp_get_alias_val(
894: p_cal_type IGS_CA_INST.cal_type%TYPE,
895: p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,