APPS.IGS_AS_VAL_AIEM dependencies on IGS_AS_ASSESSMNT_ITM

Line 36: p_ass_id IGS_AS_ASSESSMNT_ITM_ALL.ass_id%TYPE ,

32: END assp_val_aiem_catqty;
33: --
34: -- Retrofitted
35: FUNCTION assp_val_ai_exmnbl(
36: p_ass_id IGS_AS_ASSESSMNT_ITM_ALL.ass_id%TYPE ,
37: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
38: RETURN BOOLEAN AS
39:
40: BEGIN -- assp_val_ai_exmnbl

Line 46: IGS_AS_ASSESSMNT_ITM ai

42: DECLARE
43: CURSOR c_atyp IS
44: SELECT 'x'
45: FROM IGS_AS_ASSESSMNT_TYP atyp,
46: IGS_AS_ASSESSMNT_ITM ai
47: WHERE atyp.assessment_type = ai.assessment_type AND
48: ai.ass_id = p_ass_id AND
49: atyp.examinable_ind = 'N';
50: v_atyp_exists VARCHAR2(1);