DBA Data[Home] [Help]

APPS.QP_UPDATE_FORMULAPRICE_PVT dependencies on QP_PRICE_FORMULAS_VL

Line 37: FROM qp_price_formulas_vl

33: CURSOR qp_price_formulas_cur(a_price_formula_id NUMBER,
34: a_retrieve_all_flag VARCHAR2)
35: IS
36: SELECT *
37: FROM qp_price_formulas_vl
38: WHERE price_formula_id = DECODE (a_retrieve_all_flag,
39: 'Y', price_formula_id, a_price_formula_id)
40: AND (start_date_active IS NULL OR start_date_active <= SYSDATE)
41: AND (end_date_active IS NULL OR end_date_active >= SYSDATE);