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 1060: FROM cn_commission_headers_all ch

1056: AND ((g_calc_type = 'COMMISSION' AND cl.trx_type NOT IN ('BONUS', 'GRP', 'FORECAST')) OR
1057: (g_calc_type = 'FORECAST' AND cl.trx_type = 'FORECAST'))
1058: AND exists
1059: (SELECT 1
1060: FROM cn_commission_headers_all ch
1061: WHERE ch.commission_header_id = cl.commission_header_id
1062: AND ch.role_id = srp.role_id
1063: AND ch.quota_id = srp.quota_id
1064: AND substr(ch.pre_processed_code,3,1) = 'N'