APPS.IGS_CA_GEN_001 dependencies on IGS_CA_DA_INST_V

Line 209: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

205: cst_null CONSTANT VARCHAR2(4) := 'NULL';
206: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
207: v_start_dt IGS_CA_INST.start_dt%TYPE;
208: v_end_dt IGS_CA_INST.end_dt%TYPE;
209: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
210: v_within BOOLEAN;
211: v_before BOOLEAN;
212: v_after BOOLEAN;
213: CURSOR c_sgcc IS

Line 230: FROM IGS_CA_DA_INST_V daiv

226: cp_related_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
227: cp_related_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
228: cp_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE) IS
229: SELECT daiv.alias_val
230: FROM IGS_CA_DA_INST_V daiv
231: WHERE daiv.CAL_TYPE = cp_related_cal_type AND
232: daiv.ci_sequence_number = cp_related_ci_sequence_number AND
233: daiv.DT_ALIAS = cp_census_dt_alias;
234: BEGIN