APPS.IGS_AS_VAL_ASST dependencies on IGS_AS_ASSESSOR_TYPE

Line 19: FROM IGS_AS_ASSESSOR_TYPE

15: cst_no CONSTANT CHAR := 'N';
16: v_asst_count NUMBER;
17: CURSOR c_asst IS
18: SELECT COUNT(*)
19: FROM IGS_AS_ASSESSOR_TYPE
20: WHERE dflt_ind = cst_yes AND
21: closed_ind = cst_no;
22: BEGIN
23: -- Set the default message number