APPS.CN_UPG_PMT_TRXNS_PKG dependencies on CN_COMMISSION_LINES_ALL

Line 65: l_table_name varchar2(30) := 'CN_COMMISSION_LINES_ALL';

61: IS
62:
63: l_worker_id number;
64: l_product varchar2(30) := 'CN';
65: l_table_name varchar2(30) := 'CN_COMMISSION_LINES_ALL';
66: l_update_name varchar2(30) := 'CNUPMTCL.5';
67: l_status varchar2(30);
68: l_industry varchar2(30);
69: l_retstatus boolean;

Line 133: update /*+ rowid(CL) */ cn_commission_lines_all cl

129:
130: -- Code your update logic here
131: fnd_file.put_line(FND_FILE.LOG, 'updating commission lines posting column to UNPOSTED ');
132:
133: update /*+ rowid(CL) */ cn_commission_lines_all cl
134: set posting_status = 'UNPOSTED',
135: last_update_date = sysdate
136: where posting_status is NULL
137: and cl.rowid between l_start_rowid and l_end_rowid;