DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_UTILS dependencies on PA_AMOUNT_TYPES_VL

Line 2255: RETURN PA_AMOUNT_TYPES_VL.AMOUNT_TYPE_NAME%TYPE

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:

Line 2258: l_amount_type_name PA_AMOUNT_TYPES_VL.AMOUNT_TYPE_NAME%TYPE ;

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

Line 2264: FROM pa_amount_types_vl

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: