APPS.PO_REQAPPROVAL_INIT1 dependencies on DUAL

Line 715: from sys.dual;

711: If (ItemKey is NULL) then
712:
713: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
714: into l_seq_for_item_key
715: from sys.dual;
716:
717: l_itemkey := to_char(DocumentID) || '-' ||
718: l_seq_for_item_key;
719: else

Line 1281: from dual

1277:
1278: IF DocumentTypeCode = 'RELEASE' THEN
1279: select 'Y'
1280: into l_drop_ship_flag
1281: from dual
1282: where exists
1283: (select 'Release DropShip Shipment Exists'
1284: from po_line_locations
1285: where po_release_id = DocumentId

Line 1291: from dual

1287:
1288: ELSIF DocumentTypeCode = 'PO' THEN
1289: select 'Y'
1290: into l_drop_ship_flag
1291: from dual
1292: where exists
1293: (select 'PO DropShip Shipment Exists'
1294: from po_line_locations
1295: where po_header_id = DocumentId

Line 7840: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;

7836: l_document_id := document_id;
7837:
7838: END IF;
7839:
7840: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;
7841: Err_ItemKey := to_char(l_document_id) || '-' || l_seq;
7842:
7843:
7844: x_progress := 'PO_REQAPPROVAL_INIT1.send_error_notif: 50'

Line 8819: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;

8815: l_accepting_party varchar2(1);
8816: begin
8817: -- Bug 2850566
8818: -- Commented out the select statement as it is handled in the PO_ACCEPTANCES rowhandler
8819: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;
8820:
8821: -- commented out the usage of accptance_type (FPI)
8822: /* x_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => itemtype,
8823: itemkey => itemkey,