DBA Data[Home] [Help]

APPS.IGS_PS_VAL_ATL dependencies on IGS_GE_REF_CD_TYPE

Line 125: l_mandatory_flag IGS_GE_REF_CD_TYPE.mandatory_flag%TYPE;

121: p_reference_type IN VARCHAR2)
122: RETURN BOOLEAN AS
123: BEGIN
124: DECLARE
125: l_mandatory_flag IGS_GE_REF_CD_TYPE.mandatory_flag%TYPE;
126: CURSOR c_mandatory_flag IS
127: SELECT mandatory_flag
128: FROM IGS_GE_REF_CD_TYPE
129: WHERE reference_cd_type = p_reference_type;

Line 128: FROM IGS_GE_REF_CD_TYPE

124: DECLARE
125: l_mandatory_flag IGS_GE_REF_CD_TYPE.mandatory_flag%TYPE;
126: CURSOR c_mandatory_flag IS
127: SELECT mandatory_flag
128: FROM IGS_GE_REF_CD_TYPE
129: WHERE reference_cd_type = p_reference_type;
130: BEGIN
131: OPEN c_mandatory_flag;
132: FETCH c_mandatory_flag INTO l_mandatory_flag;