DBA Data[Home] [Help]

APPS.CN_CALC_POPULATE_PVT dependencies on CN_COMMISSION_HEADERS_ALL

Line 382: cn_commission_headers_all ch,

378: ch.role_id,
379: ch.quota_id,
380: ch.revenue_class_id
381: FROM cn_commission_lines_all cl,
382: cn_commission_headers_all ch,
383: cn_process_batches_all pb
384: WHERE pb.physical_batch_id = p_physical_batch_id
385: AND cl.credited_salesrep_id = pb.salesrep_id
386: AND cl.processed_period_id between pb.period_id AND pb.end_period_id

Line 999: FROM cn_commission_headers_all ch

995: AND ((g_calc_type = 'COMMISSION' AND cl.trx_type NOT IN ('BONUS', 'GRP', 'FORECAST')) OR
996: (g_calc_type = 'FORECAST' AND cl.trx_type = 'FORECAST'))
997: AND exists
998: (SELECT 1
999: FROM cn_commission_headers_all ch
1000: WHERE ch.commission_header_id = cl.commission_header_id
1001: AND ch.role_id = srp.role_id
1002: AND ch.quota_id = srp.quota_id
1003: AND substr(ch.pre_processed_code,3,1) = 'N'