DBA Data[Home] [Help]

APPS.QP_VALIDATE_CURR_LISTS dependencies on QP_PRICE_FORMULAS_VL

Line 103: FROM qp_price_formulas_vl

99:
100: /*
101: SELECT 'X'
102: INTO l_dummy_c
103: FROM qp_price_formulas_vl
104: WHERE trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
105: and nvl(end_date_active, trunc(sysdate))
106: and price_formula_id = p_CURR_LISTS_rec.base_markup_formula_id;
107: */

Line 113: FROM qp_price_formulas_vl fh

109: -- Only those formulas which do not have a line component of type_code = 'PLL' can
110: -- be attached to a multi-currency list
111: SELECT 'X'
112: INTO l_dummy_c
113: FROM qp_price_formulas_vl fh
114: WHERE trunc(sysdate) between nvl(fh.start_date_active, trunc(sysdate))
115: and nvl(fh.end_date_active, trunc(sysdate))
116: and fh.price_formula_id = p_CURR_LISTS_rec.base_markup_formula_id
117: and not exists (Select 'x'