APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_PRICE_FORMULAS_B

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

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

Line 391: FROM qp_price_formulas_b

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

Line 1447: SELECT formula into l_formula from qp_price_formulas_b

1443:
1444: l_formula_name := p_formula_name;
1445: --added for display of right message in case of undefined step
1446: -- query on formula ID instead of name, SQL repos
1447: SELECT formula into l_formula from qp_price_formulas_b
1448: WHERE price_formula_id = p_price_formula_id;
1449:
1450: SELECT count(*) into l_no_of_comps from qp_price_formula_lines
1451: WHERE price_formula_id = p_price_formula_id;