DBA Data[Home] [Help]

APPS.CN_UPG_PMT_TRXNS_PKG dependencies on CN_COMMISSION_HEADERS_ALL

Line 287: FROM cn_payment_transactions_all pmt, cn_commission_headers_all ch

283: and q.org_id(+) = p.org_id
284: and p.org_id = pmt.org_id
285: )
286: END AS new_processed_date
287: FROM cn_payment_transactions_all pmt, cn_commission_headers_all ch
288: WHERE pmt.rowid BETWEEN l_start_rowid and l_end_rowid
289: AND pmt.commission_header_id = ch.commission_header_id (+)
290: AND pmt.org_id = ch.org_id (+)
291: ) SET processed_date = new_processed_date,