APPS.IGS_AS_VAL_UAI dependencies on IGS_CA_DA_INST_V

Line 155: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

151: -- provided the efffective date is before the cutoff date.
152: DECLARE
153: cst_one CONSTANT NUMBER := 1;
154: v_ass_item_cutoff_dt_alias IGS_AS_CAL_CONF.ass_item_cutoff_dt_alias%TYPE;
155: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
156: CURSOR c_sacc IS
157: SELECT ass_item_cutoff_dt_alias
158: FROM IGS_AS_CAL_CONF
159: WHERE s_control_num = cst_one;

Line 165: FROM IGS_CA_DA_INST_V

161: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
162: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
163: cp_dt_alias IGS_AS_CAL_CONF.ass_item_cutoff_dt_alias%TYPE) IS
164: SELECT alias_val
165: FROM IGS_CA_DA_INST_V
166: WHERE cal_type = cp_cal_type AND
167: ci_sequence_number = cp_ci_sequence_number AND
168: dt_alias = cp_dt_alias
169: ORDER BY alias_val DESC;