APPS.IGS_EN_GEN_014 dependencies on IGS_EN_CAL_CONF

Line 602: FROM igs_en_cal_conf secc

598:
599: CURSOR c_s_enr_cal_conf
600: IS
601: SELECT secc.load_effect_dt_alias
602: FROM igs_en_cal_conf secc
603: WHERE secc.s_control_num = 1;
604:
605: l_load_effect_dt_alias igs_en_cal_conf.LOAD_EFFECT_DT_ALIAS%TYPE;
606:

Line 605: l_load_effect_dt_alias igs_en_cal_conf.LOAD_EFFECT_DT_ALIAS%TYPE;

601: SELECT secc.load_effect_dt_alias
602: FROM igs_en_cal_conf secc
603: WHERE secc.s_control_num = 1;
604:
605: l_load_effect_dt_alias igs_en_cal_conf.LOAD_EFFECT_DT_ALIAS%TYPE;
606:
607: BEGIN
608:
609: --fetch load effective date alias from enrollment calendar configuration

Line 694: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE)

690: --------------------------------------------------------------------*/
691:
692: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
693: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
694: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE)
695: IS
696: SELECT daiv.alias_val
697: FROM igs_ca_da_inst_v daiv
698: WHERE daiv.cal_type = cp_cal_type

Line 703: l_load_effect_dt_alias igs_en_cal_conf.LOAD_EFFECT_DT_ALIAS%TYPE;

699: AND daiv.ci_sequence_number = cp_ci_sequence_number
700: AND daiv.dt_alias = cp_load_effect_dt_alias;
701:
702: l_all_cur_load_cal_info_str VARCHAR2(2000);
703: l_load_effect_dt_alias igs_en_cal_conf.LOAD_EFFECT_DT_ALIAS%TYPE;
704: l_all_cur_load_cal_info load_cal_table_type;
705: isloaddtaliasfound BOOLEAN;
706: BEGIN
707: