APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on DUAL

Line 202: from dual;

198:
199:
200: select qp_pricing_attr_group_no_s.nextval
201: into l_attr_grp_s
202: from dual;
203:
204: select (-1*PL.ROUNDING_FACTOR),
205: NVL(FC.MINIMUM_ACCOUNTABLE_UNIT,-1)
206: into l_rounding_factor, l_min_acct_unit

Line 246: From Dual

242: */
243: l_already_exists := 0;
244: Select 1
245: Into l_already_exists
246: From Dual
247: Where Exists
248: (Select Null
249: from qp_pricing_attributes qppa
250: where qppa.list_header_id = p_price_list_id

Line 332: FROM dual;

328: IF v_result_code = 1 THEN
329: SELECT decode(l_min_acct_unit,-1,round(nvl(v_item_cost,0), l_rounding_factor),
330: round(nvl(v_item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
331: INTO l_price
332: FROM dual;
333: ELSE
334: l_price := 0;
335: END IF;
336: ELSE

Line 404: FROM dual;

400: IF v_result_code = 1 THEN
401: SELECT decode(l_min_acct_unit,-1,round(nvl(v_item_cost,0), l_rounding_factor),
402: round(nvl(v_item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
403: INTO l_price
404: FROM dual;
405: ELSE
406: l_price := 0;
407: END IF;
408: ELSE

Line 441: from dual;

437: and mtl.organization_id = p_organization_id;
438:
439: select qp_list_lines_s.nextval
440: into l_list_line_id
441: from dual;
442: -- 10185331
443: SELECT orig_system_header_ref INTO
444: l_orig_sys_header_ref
445: FROM qp_list_headers_all_b

Line 591: From Dual

587: */
588: l_already_exists := 0;
589: Select 1
590: Into l_already_exists
591: From Dual
592: Where Exists
593: (Select Null
594: from qp_pricing_attributes qppa
595: where qppa.list_header_id = p_price_list_id