DBA Data[Home] [Help]

APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on DUAL

Line 181: from dual;

177:
178:
179: select qp_pricing_attr_group_no_s.nextval
180: into l_attr_grp_s
181: from dual;
182:
183: select (-1*PL.ROUNDING_FACTOR),
184: NVL(FC.MINIMUM_ACCOUNTABLE_UNIT,-1)
185: into l_rounding_factor, l_min_acct_unit

Line 222: From Dual

218: */
219: l_already_exists := 0;
220: Select 1
221: Into l_already_exists
222: From Dual
223: Where Exists
224: (Select Null
225: from qp_pricing_attributes qppa
226: where qppa.list_header_id = p_price_list_id

Line 325: from dual;

321: and mtl.organization_id = p_organization_id;
322:
323: select qp_list_lines_s.nextval
324: into l_list_line_id
325: from dual;
326:
327: insert
328: into qp_list_lines
329: (LIST_LINE_ID,

Line 466: From Dual

462: */
463: l_already_exists := 0;
464: Select 1
465: Into l_already_exists
466: From Dual
467: Where Exists
468: (Select Null
469: from qp_pricing_attributes qppa
470: where qppa.list_header_id = p_price_list_id