APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_COMMISSION_LINES

Line 130: cn_commission_lines_all cl

126: and a.org_id = b.org_id
127: and a.start_date <= nvl(b.end_date, a.end_date)
128: and a.end_date >= b.start_date
129: group by b.payee_id) pb,
130: cn_commission_lines_all cl
131: where pb.payee_id = spa.payee_id
132: and pb.start_date <= nvl(spa.end_date, pb.end_date)
133: and pb.end_date >= spa.start_date
134: and spa.org_id = g_org_id

Line 217: FROM cn_commission_lines_all cl

213: SELECT SUM(Decode(cl.pending_status, 'Y', 0,
214: Decode(cl.trx_type, 'ADV', 0, 'REC', 0, 'CHG', 0,
215: 'FORECAST', 0, 'BONUS', 0,
216: Nvl(cl.commission_amount,0)))) comm_earned_ptd
217: FROM cn_commission_lines_all cl
218: WHERE cl.credited_salesrep_id = l_salesrep_id
219: AND cl.pay_period_id = l_period_id
220: AND cl.role_id = l_role_id
221: AND cl.quota_id = l_quota_id

Line 232: FROM cn_commission_lines_all cl,

228:
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

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: --(

Line 843: FROM cn_commission_lines_all cl,

839: FOR class IN revenue_classes LOOP
840: UPDATE cn_srp_per_quota_rc_all rc
841: SET period_to_date =
842: (SELECT nvl(sum(cl.perf_achieved), 0)
843: FROM cn_commission_lines_all cl,
844: cn_quota_rules_all qr
845: WHERE cl.credited_Salesrep_id = p_srp_pe_subledger.salesrep_id
846: AND cl.quota_id = p_srp_pe_subledger.quota_id
847: AND cl.processed_period_id = p_srp_pe_subledger.accu_period_id

Line 882: FROM cn_commission_lines_all cl,

878: FOR class IN revenue_classes LOOP
879: UPDATE cn_srp_per_quota_rc_all rc
880: SET period_to_date =
881: (SELECT nvl(sum(cl.perf_achieved), 0)
882: FROM cn_commission_lines_all cl,
883: cn_quota_rules_all qr
884: WHERE cl.credited_Salesrep_id = p_srp_pe_subledger.salesrep_id
885: AND cl.quota_id = p_srp_pe_subledger.quota_id
886: AND cl.processed_period_id = p_srp_pe_subledger.accu_period_id