DBA Data[Home] [Help]

APPS.IGS_AS_VAL_UAI dependencies on IGS_EN_SU_ATTEMPT

Line 161: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

157: SELECT ass_item_cutoff_dt_alias
158: FROM IGS_AS_CAL_CONF
159: WHERE s_control_num = cst_one;
160: CURSOR c_daiv(
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

Line 162: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

158: FROM IGS_AS_CAL_CONF
159: WHERE s_control_num = cst_one;
160: CURSOR c_daiv(
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