APPS.QP_VALIDATE_CURR_DETAILS dependencies on QP_PRICE_FORMULAS_VL

Line 200: FROM qp_price_formulas_vl fh

196: oe_debug_pub.add('VALIDATE Details price_formula');
197:
198: SELECT 'X'
199: INTO l_dummy_c
200: FROM qp_price_formulas_vl fh
201: WHERE trunc(sysdate) between nvl(fh.start_date_active, trunc(sysdate))
202: and nvl(fh.end_date_active, trunc(sysdate))
203: and fh.price_formula_id = p_CURR_DETAILS_rec.price_formula_id
204: and not exists (Select 'x'

Line 225: FROM qp_price_formulas_vl fh

221: oe_debug_pub.add('VALIDATE - Details price_formula does not have line of type MV');
222:
223: SELECT 'X'
224: INTO l_dummy_c
225: FROM qp_price_formulas_vl fh
226: WHERE trunc(sysdate) between nvl(fh.start_date_active, trunc(sysdate))
227: and nvl(fh.end_date_active, trunc(sysdate))
228: and fh.price_formula_id = p_CURR_DETAILS_rec.price_formula_id
229: and not exists (Select 'x'

Line 282: FROM qp_price_formulas_vl

278:
279: /*
280: SELECT 'X'
281: INTO l_dummy_c
282: FROM qp_price_formulas_vl
283: WHERE trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
284: and nvl(end_date_active, trunc(sysdate))
285: and price_formula_id = p_CURR_DETAILS_rec.markup_formula_id;
286: */

Line 292: FROM qp_price_formulas_vl fh

288: -- Only those formulas which do not have a line component of type_code = 'PLL' can
289: -- be attached to a multi-currency list
290: SELECT 'X'
291: INTO l_dummy_c
292: FROM qp_price_formulas_vl fh
293: WHERE trunc(sysdate) between nvl(fh.start_date_active, trunc(sysdate))
294: and nvl(fh.end_date_active, trunc(sysdate))
295: and fh.price_formula_id = p_CURR_DETAILS_rec.markup_formula_id
296: and not exists (Select 'x'