APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_SRP_PER_QUOTA_RC_ALL

Line 582: FROM cn_srp_per_quota_rc_all

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

Line 838: UPDATE cn_srp_per_quota_rc_all rc

834: exception
835:
836: when no_component then
837: FOR class IN revenue_classes LOOP
838: UPDATE cn_srp_per_quota_rc_all rc
839: SET period_to_date =
840: (SELECT nvl(sum(cl.perf_achieved), 0)
841: FROM cn_commission_lines_all cl,
842: cn_quota_rules_all qr

Line 877: UPDATE cn_srp_per_quota_rc_all rc

873:
874: ELSE
875: -- sum transactions
876: FOR class IN revenue_classes LOOP
877: UPDATE cn_srp_per_quota_rc_all rc
878: SET period_to_date =
879: (SELECT nvl(sum(cl.perf_achieved), 0)
880: FROM cn_commission_lines_all cl,
881: cn_quota_rules_all qr