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 545: FROM cn_commission_lines cl, cn_commission_headers_all ch

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