APPS.IGS_EN_GEN_001 dependencies on IGS_EN_CAL_CONF

Line 39: v_effect_enr_strt_dt_alias IGS_EN_CAL_CONF.effect_enr_strt_dt_alias%TYPE;

35: AS
36: BEGIN
37: DECLARE
38: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
39: v_effect_enr_strt_dt_alias IGS_EN_CAL_CONF.effect_enr_strt_dt_alias%TYPE;
40: v_record_found BOOLEAN;
41: CURSOR c_s_enr_cal_conf IS
42: SELECT effect_enr_strt_dt_alias
43: FROM IGS_EN_CAL_CONF

Line 43: FROM IGS_EN_CAL_CONF

39: v_effect_enr_strt_dt_alias IGS_EN_CAL_CONF.effect_enr_strt_dt_alias%TYPE;
40: v_record_found BOOLEAN;
41: CURSOR c_s_enr_cal_conf IS
42: SELECT effect_enr_strt_dt_alias
43: FROM IGS_EN_CAL_CONF
44: WHERE s_control_num = 1;
45: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
46: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
47: cp_effective_dt DATE) IS

Line 66: -- IGS_EN_CAL_CONF.effect_enr_strt_dt_alias column. If no match is determinable

62: -- this module alculates the current instance of academic period calendar
63: -- for the nominated academic calendar type. This is determined by searching
64: -- for the ?effective enrolment start date alias? within the academic
65: -- calendar instance. The dt_alias to search for is located in the
66: -- IGS_EN_CAL_CONF.effect_enr_strt_dt_alias column. If no match is determinable
67: -- then the returned sequence number will be set to 0.
68: v_record_found := FALSE;
69: p_sequence_number := 0;
70: OPEN c_s_enr_cal_conf;