2251: END CONV_MC_ATTR_MEANING_TO_CODE ;
2252:
2253: FUNCTION GET_AMOUNT_TYPE_NAME (
2254: p_amount_type_code IN PA_AMOUNT_TYPES_B.AMOUNT_TYPE_CODE%TYPE )
2255: RETURN PA_AMOUNT_TYPES_VL.AMOUNT_TYPE_NAME%TYPE
2256: IS
2257:
2258: l_amount_type_name PA_AMOUNT_TYPES_VL.AMOUNT_TYPE_NAME%TYPE ;
2259:
2254: p_amount_type_code IN PA_AMOUNT_TYPES_B.AMOUNT_TYPE_CODE%TYPE )
2255: RETURN PA_AMOUNT_TYPES_VL.AMOUNT_TYPE_NAME%TYPE
2256: IS
2257:
2258: l_amount_type_name PA_AMOUNT_TYPES_VL.AMOUNT_TYPE_NAME%TYPE ;
2259:
2260: BEGIN
2261:
2262: SELECT amount_type_name
2260: BEGIN
2261:
2262: SELECT amount_type_name
2263: INTO l_amount_type_name
2264: FROM pa_amount_types_vl
2265: WHERE amount_type_code = p_amount_type_code;
2266:
2267: RETURN l_amount_type_name;
2268: