APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_COMMISSION_LINES_ALL

Line 1447: FROM cn_commission_lines_all ccl

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