APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_SRP_PER_QUOTA_RC_ALL

Line 584: FROM cn_srp_per_quota_rc_all

580: AND f.org_id(+) = q.org_id;
581:
582: CURSOR revenue_classes is
583: SELECT revenue_class_id
584: FROM cn_srp_per_quota_rc_all
585: WHERE salesrep_id = p_srp_pe_subledger.salesrep_id
586: AND period_id = p_srp_pe_subledger.accu_period_id
587: AND quota_id = p_srp_pe_subledger.quota_id
588: AND srp_plan_assign_id = p_srp_pe_subledger.srp_plan_assign_id;

Line 840: UPDATE cn_srp_per_quota_rc_all rc

836: exception
837:
838: when no_component then
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

Line 879: UPDATE cn_srp_per_quota_rc_all rc

875:
876: ELSE
877: -- sum transactions
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