APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_COMMISSION_LINES_ALL

Line 1445: FROM cn_commission_lines_all ccl

1441: -- 12/27/04 : Bug 4090737 Performance Issue Creating Worksheet START
1442: CURSOR get_comm_total(p_period_id NUMBER) IS
1443: SELECT
1444: nvl(SUM(nvl(commission_amount, 0)), 0)
1445: FROM cn_commission_lines_all ccl
1446: WHERE credited_salesrep_id = p_worksheet_rec.salesrep_id
1447: AND processed_period_id <= p_period_id
1448: AND credit_type_id = g_credit_type_id
1449: AND status = 'CALC'