APPS.AP_AUTO_DM_CREATION_PKG dependencies on DUAL

Line 986: SELECT ap_batches_s.nextval INTO p_batch_id FROM dual;

982: curr_calling_sequence := p_calling_sequence ||' <- Create_Invoice_batch';
983:
984: debug_info := 'Insert into ap_batches';
985:
986: SELECT ap_batches_s.nextval INTO p_batch_id FROM dual;
987:
988: --Bug fix:1858452
989: --Note: When matched to a PO , po_distribution_id is not populated
990: --in rcv_transactions, hence need to join using po_header_id...

Line 1279: FROM dual;

1275: -- Added a hyphen for the invoice number between receipt_num and the sequence
1276:
1277: SELECT p_receipt_num||'-'||AP_INVOICES_S1.nextval
1278: INTO l_invoice_num
1279: FROM dual;
1280:
1281: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1282: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1283: 'Invoice Number := '||l_invoice_num);

Line 1560: SELECT ap_invoices_s.nextval INTO l_invoice_id FROM dual;

1556: debug_info);
1557: END IF;
1558:
1559:
1560: SELECT ap_invoices_s.nextval INTO l_invoice_id FROM dual;
1561:
1562: debug_info := 'Inserting row in ap_invoices';
1563: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,