APPS.PO_DOCUMENT_CHECKS_GRP dependencies on DUAL

Line 1490: FROM dual

1486: -- for the shipments of this line, 0 otherwise.
1487: -- SQL Why: To prevent price changes if there are pending transactions.
1488: SELECT count(*)
1489: INTO l_pending_rcv_transactions
1490: FROM dual
1491: WHERE EXISTS
1492: ( SELECT 1
1493: FROM rcv_transactions_interface RTI, po_line_locations_all PLL
1494: WHERE PLL.po_line_id = p_po_line_id

Line 1710: FROM dual

1706: -- for the shipments of this line, 0 otherwise.
1707: -- SQL Why: To prevent price changes if there are pending transactions.
1708: SELECT count(*)
1709: INTO l_pending_rcv_transactions
1710: FROM dual
1711: WHERE EXISTS
1712: ( SELECT 1
1713: FROM rcv_transactions_interface RTI
1714: WHERE RTI.po_line_location_id = p_line_location_id

Line 1841: FROM sys.dual;

1837: -- SQL What: Get the id from the given nline report sequence
1838: -- SQL Why: Used for the new combined online report below.
1839: SELECT po_online_report_text_s.nextval
1840: INTO x_new_report_id
1841: FROM sys.dual;
1842:
1843: IF (PO_LOG.d_stmt) THEN
1844: PO_LOG.stmt(d_module,d_progress,'After got the new id for combined online report');
1845: END IF;