APPS.CN_MASS_ADJUST_UTIL dependencies on CN_TRX_BATCHES

Line 493: trx_batch_name cn_trx_batches.trx_batch_name%TYPE,

489: reason cn_lookups.meaning%TYPE,
490: revenue_class_name cn_revenue_classes.name%TYPE,
491: revenue_type_disp cn_lookups.meaning%TYPE,
492: adjust_status_disp cn_lookups.meaning%TYPE,
493: trx_batch_name cn_trx_batches.trx_batch_name%TYPE,
494: terr_id cn_comm_lines_api.terr_id%TYPE,
495: preserve_credit_override_flag cn_comm_lines_api.preserve_credit_override_flag%TYPE
496: );
497: l_header_rec header_rec;

Line 610: 'cn_lookups CLAD, cn_revenue_classes CNR, cn_quotas CQ, cn_trx_batches CTB, '||

606: --Added for Crediting bug
607: 'API.terr_id, API.preserve_credit_override_flag '||
608: 'FROM cn_period_statuses CPSP, cn_salesreps RSD, cn_commission_headers_all CCH, '||
609: 'cn_lookups CLT, cn_lookups CLR, cn_lookups CLS, cn_lookups CLRV, '||
610: 'cn_lookups CLAD, cn_revenue_classes CNR, cn_quotas CQ, cn_trx_batches CTB, '||
611: -- Modified for Crediting Bug
612: 'cn_comm_lines_api API '||
613: 'WHERE CCH.direct_salesrep_id = RSD.salesrep_id '||
614: --Modified for Crediting Bug