APPS.IGS_EN_GEN_004 dependencies on IGS_EN_CAL_CONF

Line 297: FROM IGS_EN_CAL_CONF secc,

293: DECLARE
294: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
295: CURSOR c_alias_val IS
296: SELECT daiv.alias_val
297: FROM IGS_EN_CAL_CONF secc,
298: IGS_CA_DA_INST_V daiv
299: WHERE secc.s_control_num = 1 AND
300: daiv.dt_alias = DECODE(p_date_type,
301: 'ENROLLED',NVL(secc.enrolled_rule_cutoff_dt_alias, 'NULL'),

Line 433: -- IGS_EN_CAL_CONF. enr_form_due_dt_alias (the latest date is selected)

429: -- Get the enrolment form due date for a nominated student IGS_PS_COURSE attempt
430: -- enrolment record. The logic is,
431: -- If a student has the IGS_AS_SC_ATMPT_ENR.enr_form_due_dt set, then this
432: -- is used. Else, it is search for in the enrolment period matching the
433: -- IGS_EN_CAL_CONF. enr_form_due_dt_alias (the latest date is selected)
434: DECLARE
435: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;
436: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
437: CURSOR c_scae IS

Line 454: FROM IGS_EN_CAL_CONF secc,

450: daiv.ci_sequence_number,
451: daiv.CAL_TYPE,
452: daiv.DT_ALIAS,
453: daiv.sequence_number) ) alias_val
454: FROM IGS_EN_CAL_CONF secc,
455: IGS_CA_DA_INST daiv
456: WHERE secc.s_control_num = 1 AND
457: daiv.cal_type = p_cal_type AND
458: daiv.ci_sequence_number = p_ci_sequence_number AND

Line 554: l_record_open_dt_alias IGS_EN_CAL_CONF.record_open_dt_alias%TYPE;

550: **********************************************************************************************************************************************************/
551: BEGIN
552: DECLARE
553: l_person_type IGS_PE_USR_ARG.person_type%TYPE;
554: l_record_open_dt_alias IGS_EN_CAL_CONF.record_open_dt_alias%TYPE;
555: l_record_cutoff_dt_alias IGS_EN_CAL_CONF.record_cutoff_dt_alias%TYPE;
556: l_daiv_rec_found BOOLEAN;
557: l_rec_open_dt_pass BOOLEAN;
558: l_open_dt IGS_CA_DA_INST_V.alias_val%TYPE;

Line 555: l_record_cutoff_dt_alias IGS_EN_CAL_CONF.record_cutoff_dt_alias%TYPE;

551: BEGIN
552: DECLARE
553: l_person_type IGS_PE_USR_ARG.person_type%TYPE;
554: l_record_open_dt_alias IGS_EN_CAL_CONF.record_open_dt_alias%TYPE;
555: l_record_cutoff_dt_alias IGS_EN_CAL_CONF.record_cutoff_dt_alias%TYPE;
556: l_daiv_rec_found BOOLEAN;
557: l_rec_open_dt_pass BOOLEAN;
558: l_open_dt IGS_CA_DA_INST_V.alias_val%TYPE;
559: l_rec_cutt_off_dt IGS_CA_DA_INST_V.alias_val%TYPE;

Line 604: FROM IGS_EN_CAL_CONF

600: AND uoo_id = cp_uoo_id;
601:
602: CURSOR c_recdt_alias_usec_lvl2 IS
603: SELECT record_open_dt_alias
604: FROM IGS_EN_CAL_CONF
605: WHERE s_control_num = 1;
606:
607: CURSOR c_recdt_alias_inst_lvl IS
608: SELECT record_open_dt_alias,

Line 610: FROM IGS_EN_CAL_CONF

606:
607: CURSOR c_recdt_alias_inst_lvl IS
608: SELECT record_open_dt_alias,
609: record_cutoff_dt_alias
610: FROM IGS_EN_CAL_CONF
611: WHERE s_control_num = 1;
612:
613: l_non_std_usec_ind IGS_PS_UNIT_OFR_OPT.non_std_usec_ind%TYPE;
614: