DBA Data[Home] [Help]

APPS.QP_VALIDATE_CURR_LISTS dependencies on QP_PRICE_FORMULA_LINES

Line 118: From qp_price_formula_lines fl

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'
118: From qp_price_formula_lines fl
119: Where fl.price_formula_id = fh.price_formula_id
120: and fl.PRICE_FORMULA_LINE_TYPE_CODE = 'PLL'
121: and trunc(sysdate) between nvl(fl.start_date_active, trunc(sysdate))
122: and nvl(fl.end_date_active, trunc(sysdate)));