APPS.IGS_AS_VAL_AIEM dependencies on IGS_AS_EXM_MTRL_TYPE

Line 75: p_exam_material_type IGS_AS_EXM_MTRL_TYPE.exam_material_type%TYPE ,

71: END assp_val_ai_exmnbl;
72: --
73: -- Retrofitted
74: FUNCTION assp_val_exmt_closed(
75: p_exam_material_type IGS_AS_EXM_MTRL_TYPE.exam_material_type%TYPE ,
76: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
77: RETURN BOOLEAN AS
78:
79: BEGIN -- assp_val_exmt_closed

Line 84: FROM IGS_AS_EXM_MTRL_TYPE

80: -- Validate the exam material type closed indicator.
81: DECLARE
82: CURSOR c_exmt IS
83: SELECT 'x'
84: FROM IGS_AS_EXM_MTRL_TYPE
85: WHERE exam_material_type = p_exam_material_type AND
86: closed_ind = 'Y';
87: v_exmt_exists VARCHAR2(1);
88: BEGIN