APPS.IGS_CA_VAL_CI dependencies on IGS_CA_DA_INST_V

Line 128: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;

124: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
125: v_other_detail VARCHAR2(255);
126: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
127: v_cal_instance_rltshp_rec IGS_CA_INST_REL%ROWTYPE;
128: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;
129: v_new_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
130: v_old_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
131: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
132: -- define cursors

Line 153: FROM IGS_CA_DA_INST_V

149: sub_ci_sequence_number = p_sequence_number;
150: CURSOR c_dt_alias_instance
151: IS
152: SELECT *
153: FROM IGS_CA_DA_INST_V
154: WHERE cal_type = p_cal_type AND
155: ci_sequence_number = p_sequence_number;
156: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
157: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)