APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on DUAL

Line 2681: FROM SYS.DUAL;

2677:
2678: l_src_price_adjustment_id := l_po_price_adjustment_record.price_adjustment_id;
2679: SELECT po_price_adjustments_s.nextval
2680: INTO l_po_price_adjustment_record.price_adjustment_id
2681: FROM SYS.DUAL;
2682:
2683: --reset Standard and other columns
2684: l_po_price_adjustment_record.created_by := fnd_global.user_id;
2685: l_po_price_adjustment_record.creation_date := SYSDATE;

Line 3084: FROM SYS.DUAL;

3080:
3081: l_src_price_adjustment_id := l_po_price_adjustment_record.price_adjustment_id;
3082: SELECT po_price_adjustments_s.nextval
3083: INTO l_po_price_adjustment_record.price_adjustment_id
3084: FROM SYS.DUAL;
3085:
3086: --reset Standard columns
3087: l_po_price_adjustment_record.created_by := fnd_global.user_id;
3088: l_po_price_adjustment_record.creation_date := SYSDATE;

Line 3427: FROM DUAL

3423: , p_adj_rec.ac_attribute15
3424: , p_adj_rec.operand_per_pqty
3425: , p_adj_rec.adjusted_amount_per_pqty
3426: , 1 -- LOCK_CONTROL
3427: FROM DUAL
3428: );
3429: --Exception will be caught by the calling procedure
3430: END insert_adj_rec;
3431:

Line 3636: FROM DUAL

3632: , p_adj_rec.ac_attribute15
3633: , p_adj_rec.operand_per_pqty
3634: , p_adj_rec.adjusted_amount_per_pqty
3635: , 1 -- LOCK_CONTROL
3636: FROM DUAL
3637: );
3638: --Exception will be caught by the calling procedure
3639: END insert_draft_adj_rec;
3640:

Line 3798: AND ATTR.price_adjustment_id IN (SELECT p_price_adjustment_id FROM DUAL

3794: --Delete dependant fields first
3795: --Delete Price Adjustment Attributes
3796: DELETE FROM PO_PRICE_ADJ_ATTRIBS_DRAFT ATTR
3797: WHERE ATTR.draft_id = p_draft_id
3798: AND ATTR.price_adjustment_id IN (SELECT p_price_adjustment_id FROM DUAL
3799: UNION
3800: SELECT ASOC.rltd_price_adj_id
3801: FROM PO_PRICE_ADJ_ASSOCS_DRAFT ASOC
3802: WHERE ASOC.price_adjustment_id = p_price_adjustment_id);