APPS.QP_VALIDATE_CURR_DETAILS dependencies on QP_PRICE_FORMULA_LINES

Line 205: From qp_price_formula_lines fl

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'
205: From qp_price_formula_lines fl
206: Where fl.price_formula_id = fh.price_formula_id
207: and fl.PRICE_FORMULA_LINE_TYPE_CODE = 'PLL'
208: and trunc(sysdate) between nvl(fl.start_date_active, trunc(sysdate))
209: and nvl(fl.end_date_active, trunc(sysdate)));

Line 230: From qp_price_formula_lines fl

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'
230: From qp_price_formula_lines fl
231: Where fl.price_formula_id = fh.price_formula_id
232: and fl.PRICE_FORMULA_LINE_TYPE_CODE = 'MV'
233: and trunc(sysdate) between nvl(fl.start_date_active, trunc(sysdate))
234: and nvl(fl.end_date_active, trunc(sysdate)));

Line 297: From qp_price_formula_lines fl

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'
297: From qp_price_formula_lines fl
298: Where fl.price_formula_id = fh.price_formula_id
299: and fl.PRICE_FORMULA_LINE_TYPE_CODE = 'PLL'
300: and trunc(sysdate) between nvl(fl.start_date_active, trunc(sysdate))
301: and nvl(fl.end_date_active, trunc(sysdate)));