82: FROM cn_commission_headers ch
83: , cn_commission_lines cl
84: , cn_salesreps rep
85: , hz_parties hp
86: , hz_cust_accounts hca
87: WHERE cl.org_id = ch.org_id
88: AND rep.org_id = ch.org_id
89: AND cl.status = 'CALC'
90: AND cl.commission_header_id = ch.commission_header_id
187: FROM cn_commission_headers ch
188: , cn_commission_lines cl
189: , cn_salesreps rep
190: , hz_parties hp
191: , hz_cust_accounts hca
192: WHERE cl.org_id = ch.org_id
193: AND rep.org_id = ch.org_id
194: AND cl.status = 'CALC'
195: AND cl.commission_header_id = ch.commission_header_id