APPS.IGS_SS_ENR_DETAILS dependencies on IGS_EN_CAL_CONF

Line 3816: FROM igs_en_cal_conf

3812: WHERE person_type = cp_person_type;
3813:
3814: CURSOR c_cal_conf IS
3815: SELECT AUDIT_STATUS_DT_ALIAS
3816: FROM igs_en_cal_conf
3817: WHERE s_control_num = 1;
3818:
3819:
3820: cur_uv_audit_ind_rec cur_uv_audit_ind%ROWTYPE;

Line 3821: l_audit_dt_alias igs_en_cal_conf. AUDIT_STATUS_DT_ALIAS %TYPE;

3817: WHERE s_control_num = 1;
3818:
3819:
3820: cur_uv_audit_ind_rec cur_uv_audit_ind%ROWTYPE;
3821: l_audit_dt_alias igs_en_cal_conf. AUDIT_STATUS_DT_ALIAS %TYPE;
3822: l_dt_alias_val igs_ca_da_inst_v.alias_val%TYPE;
3823: BEGIN
3824:
3825: OPEN cur_uv_audit_ind(p_uoo_id);

Line 4307: FROM igs_en_cal_conf

4303:
4304: --cursor to fetch the schedule start date alias
4305: CURSOR c_cal_conf IS
4306: SELECT schedule_open_dt_alias
4307: FROM igs_en_cal_conf
4308: WHERE s_control_num = 1;
4309:
4310: l_sch_dt_alias igs_en_cal_conf.SCHEDULE_OPEN_DT_ALIAS%TYPE;
4311: l_schedule_flag igs_ca_inst_all.schedule_flag%TYPE;

Line 4310: l_sch_dt_alias igs_en_cal_conf.SCHEDULE_OPEN_DT_ALIAS%TYPE;

4306: SELECT schedule_open_dt_alias
4307: FROM igs_en_cal_conf
4308: WHERE s_control_num = 1;
4309:
4310: l_sch_dt_alias igs_en_cal_conf.SCHEDULE_OPEN_DT_ALIAS%TYPE;
4311: l_schedule_flag igs_ca_inst_all.schedule_flag%TYPE;
4312: l_dt_alias_val DATE;
4313:
4314:

Line 4676: FROM igs_en_cal_conf

4672: AND SEQUENCE_NUMBER = cp_load_seq_num;
4673:
4674: CURSOR c_cal_conf IS
4675: SELECT planning_open_dt_alias, schedule_open_dt_alias
4676: FROM igs_en_cal_conf
4677: WHERE s_control_num = 1;
4678:
4679: CURSOR c_spat_check (cp_person_id IN NUMBER,
4680: cp_course_cd IN VARCHAR2,

Line 4696: l_plan_dt_alias igs_en_cal_conf.planning_open_dt_alias %TYPE;

4692: FROM igs_pe_person_types
4693: WHERE person_type_code = p_person_type_code;
4694:
4695:
4696: l_plan_dt_alias igs_en_cal_conf.planning_open_dt_alias %TYPE;
4697: l_sch_dt_alias igs_en_cal_conf.SCHEDULE_open_DT_ALIAS%TYPE;
4698:
4699: l_plan_flag igs_ca_inst_all.planning_flag%TYPE;
4700: l_schedule_flag igs_ca_inst_all.schedule_flag%TYPE;

Line 4697: l_sch_dt_alias igs_en_cal_conf.SCHEDULE_open_DT_ALIAS%TYPE;

4693: WHERE person_type_code = p_person_type_code;
4694:
4695:
4696: l_plan_dt_alias igs_en_cal_conf.planning_open_dt_alias %TYPE;
4697: l_sch_dt_alias igs_en_cal_conf.SCHEDULE_open_DT_ALIAS%TYPE;
4698:
4699: l_plan_flag igs_ca_inst_all.planning_flag%TYPE;
4700: l_schedule_flag igs_ca_inst_all.schedule_flag%TYPE;
4701: