DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on QP_PRICE_FORMULAS_TL

Line 345: l_formula_name QP_PRICE_FORMULAS_TL.NAME%TYPE;

341:
342:
343: FUNCTION get_formula_name(p_formula_id IN NUMBER) RETURN VARCHAR2
344: IS
345: l_formula_name QP_PRICE_FORMULAS_TL.NAME%TYPE;
346: BEGIN
347: SELECT name INTO l_formula_name FROM qp_price_formulas_tl WHERE price_formula_id = p_formula_id AND language = userenv('lang');
348: return l_formula_name;
349: END get_formula_name;

Line 347: SELECT name INTO l_formula_name FROM qp_price_formulas_tl WHERE price_formula_id = p_formula_id AND language = userenv('lang');

343: FUNCTION get_formula_name(p_formula_id IN NUMBER) RETURN VARCHAR2
344: IS
345: l_formula_name QP_PRICE_FORMULAS_TL.NAME%TYPE;
346: BEGIN
347: SELECT name INTO l_formula_name FROM qp_price_formulas_tl WHERE price_formula_id = p_formula_id AND language = userenv('lang');
348: return l_formula_name;
349: END get_formula_name;
350:
351: --FUNCTION get_vo_tier_id(p_offer_id)