APPS.IGS_EN_GEN_014 dependencies on IGS_CA_DA_INST_V

Line 692: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,

688: --Who When What
689:
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

Line 693: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,

689:
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

Line 697: FROM igs_ca_da_inst_v daiv

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
699: AND daiv.ci_sequence_number = cp_ci_sequence_number
700: AND daiv.dt_alias = cp_load_effect_dt_alias;
701: