APPS.IGS_AS_VAL_NESO dependencies on IGS_PS_UNIT_VER

Line 34: FROM IGS_PS_UNIT_VER uv,

30: FROM IGS_LOOKUPS_VIEW sgcmt
31: WHERE sgcmt.LOOKUP_TYPE = p_s_grade_creation_method_type;
32: CURSOR c_uv IS
33: SELECT us.s_unit_status
34: FROM IGS_PS_UNIT_VER uv,
35: IGS_PS_UNIT_STAT us
36: WHERE uv.unit_cd = p_unit_cd AND
37: uv.version_number = p_version_number AND
38: us.UNIT_STATUS = uv.UNIT_STATUS;

Line 53: -- cannot be added against IGS_PS_UNIT_VER with a system status of

49: -- Validate the insert of a IGS_AS_NON_ENR_STDOT record.
50: -- Checks for:
51: -- cannot be added against a closed s_grade_creation_method_type
52: -- one of mark or grade must be set
53: -- cannot be added against IGS_PS_UNIT_VER with a system status of
54: -- other than 'ACTIVE'.
55: -- Person id must have at least one student course attempt of any status.
56: --- Set the default message number
57: p_message_name := null;