APPS.OPI_DBI_OPM_COGS_PKG dependencies on DUAL

Line 1310: FROM dual;

1306: --l_last_trx_id := 0;
1307: END;
1308:
1309: SELECT ap_invoice_distributions_s.NEXTVAL INTO l_new_trx_id
1310: FROM dual;
1311:
1312: l_batch_from_id := l_last_trx_id;
1313:
1314: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI ICAP COGS at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

Line 1332: FROM dual ) d

1328: l_msg );
1329:
1330: merge INTO opi_dbi_cogs_log l
1331: using ( SELECT 'COGS_ICAP' extraction_type
1332: FROM dual ) d
1333: ON ( l.extraction_type = d.extraction_type )
1334: WHEN matched THEN UPDATE SET
1335: l.transaction_id = Decode(l_status, 0, l_batch_from_id,
1336: 1, l_batch_to_id ),

Line 1559: FROM dual ) d

1555:
1556: merge INTO opi_dbi_cogs_log l
1557: using ( SELECT NULL organization_id,
1558: 'OPM_COGS_SUBLEDGER' extraction_type
1559: FROM dual ) d
1560: ON ( l.extraction_type = d.extraction_type )
1561: WHEN matched THEN UPDATE SET
1562: l.organization_id = NULL,
1563: l.transaction_id = Decode(l_status, 0, l_batch_from_id,

Line 1666: FROM dual ) d

1662:
1663: merge INTO opi_dbi_cogs_log l
1664: using ( SELECT NULL organization_id,
1665: 'OPM_COGS_SUBLEDGER' extraction_type
1666: FROM dual ) d
1667: ON ( l.extraction_type = d.extraction_type )
1668: WHEN matched THEN UPDATE SET
1669: l.organization_id = NULL,
1670: l.transaction_id = Decode(l_status, 0, l_batch_from_id,