APPS.CN_UPG_PMT_TRXNS_PKG dependencies on CN_PAYMENT_TRANSACTIONS_ALL

Line 179: l_table_name varchar2(30) := 'CN_PAYMENT_TRANSACTIONS_ALL';

175: X_Num_Workers in number)
176: IS
177: l_worker_id number;
178: l_product varchar2(30) := 'CN';
179: l_table_name varchar2(30) := 'CN_PAYMENT_TRANSACTIONS_ALL';
180: l_update_name varchar2(30) := 'CNUPPMTRX.102';
181: l_status varchar2(30);
182: l_industry varchar2(30);
183: l_retstatus boolean;

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,