DBA Data[Home] [Help]

APPS.IGS_AS_VAL_AI dependencies on IGS_AS_SU_ATMPT_ITM

Line 222: FROM IGS_AS_SU_ATMPT_ITM suaai

218: FROM IGS_AS_ASSESSMNT_TYP atyp
219: WHERE atyp.assessment_type = cp_assessment_type;
220: CURSOR c_suaai IS
221: SELECT 'x'
222: FROM IGS_AS_SU_ATMPT_ITM suaai
223: WHERE ass_id = p_ass_id AND
224: suaai.logical_delete_dt IS NULL AND
225: suaai.tracking_id IS NOT NULL;
226: -- If an examinable item, then reference must be unique across all examinable