APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_PRICE_FORMULAS_B

Line 383: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.price_formulas_cur,QP_PRICE_FORMULAS_B_PK,PRICE_FORMULA_ID,1

379: -- a.pattern_value_from_negative and a.pattern_value_to_negative
380: -- GROUP BY a.list_line_id
381: -- HAVING count(*) = a_group_count; --3520634 end
382: /*
383: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.price_formulas_cur,QP_PRICE_FORMULAS_B_PK,PRICE_FORMULA_ID,1
384: */
385: CURSOR price_formulas_cur (a_price_formula_id NUMBER,
386: a_price_effective_date DATE)
387: IS

Line 389: FROM qp_price_formulas_b

385: CURSOR price_formulas_cur (a_price_formula_id NUMBER,
386: a_price_effective_date DATE)
387: IS
388: SELECT formula
389: FROM qp_price_formulas_b
390: WHERE price_formula_id = a_price_formula_id
391: AND (start_date_active IS NULL OR
392: start_date_active <= a_price_effective_date)
393: AND (end_date_active IS NULL OR

Line 1233: SELECT formula into l_formula from qp_price_formulas_b

1229:
1230: l_formula_name := p_formula_name;
1231: --added for display of right message in case of undefined step
1232: -- query on formula ID instead of name, SQL repos
1233: SELECT formula into l_formula from qp_price_formulas_b
1234: WHERE price_formula_id = p_price_formula_id;
1235:
1236: SELECT count(*) into l_no_of_comps from qp_price_formula_lines
1237: WHERE price_formula_id = p_price_formula_id;