FUNCTION: APPS.GET_TRANSLATED_DNU_REASON

Source

1 FUNCTION      Get_Translated_DNU_Reason(P_DNU_REASON_CODE IN VARCHAR2)
2 				RETURN VARCHAR2
3 				IS
4 					l_dnu_reason VARCHAR2(500);
5 				BEGIN
6 
7 				SELECT DESCRIPTION
8 				INTO l_dnu_reason
9 				FROM  FND_LOOKUPS
10 				WHERE LOOKUP_TYPE 	= 'IEC_DNU_REASON'
11 		  		AND  LOOKUP_CODE	= P_DNU_REASON_CODE;
12 
13 				RETURN l_dnu_reason;
14 
15 				END Get_Translated_DNU_Reason;