APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_COMMISSION_HEADERS_ALL

Line 233: cn_commission_headers_all ch,

229: CURSOR bonus_cr IS
230: SELECT SUM(Decode(cl.pending_status, 'Y', 0,
231: cl.commission_amount)) bonus_earned_ptd
232: FROM cn_commission_lines_all cl,
233: cn_commission_headers_all ch,
234: cn_srp_plan_assigns_all cspa,
235: cn_role_plans_all crp,
236: cn_quotas_all cq
237: WHERE cl.credited_salesrep_id = l_salesrep_id

Line 543: FROM cn_commission_lines cl, cn_commission_headers_all ch

539: SUM(Decode(cl.pending_status, 'Y', 0,
540: Decode(cl.trx_type, 'CHG', cl.commission_amount, 0))) rec_amount_ptd,
541: SUM(Decode(cl.pending_status, 'Y', cl.commission_amount, 0)) comm_pending_ptd,
542: SUM(ch.transaction_amount) transaction_amount_ptd
543: FROM cn_commission_lines cl, cn_commission_headers_all ch
544: WHERE
545: cl.credited_salesrep_id = p_srp_pe_subledger.salesrep_id
546: --for payee enh. bug#2495614 above condition is replaced by the following code
547: --(