APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on CN_QUOTAS

Line 343: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q

339: l_start_pd NUMBER,
340: l_end_pd NUMBER,
341: l_org_id NUMBER) IS
342: select nvl(sum(balance2_dtd),0)
343: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q
344: where spa.srp_plan_assign_id = l_srp_plan_assign_id
345: and sp.srp_plan_assign_id = spa.srp_plan_assign_id
346: and sp.salesrep_id = spa.salesrep_id
347: and sp.quota_id = q.quota_id

Line 426: cn_quotas_all quota,

422: nvl(sum(cspq.commission_payed_ptd),0) earnings,
423: nvl(sum(cspq.target_amount),0) target,
424: nvl(sum(cspq.itd_target),0) itd_target
425: FROM cn_srp_period_quotas cspq,
426: cn_quotas_all quota,
427: cn_period_statuses ps,
428: cn_repositories r,
429: cn_period_statuses ps2
430: WHERE cspq.srp_plan_assign_id = p_srp_plan_assign_id

Line 466: cn_quotas q,

462: -- To get Annual Quota Target and percent
463: CURSOR annual_quota_cur(a_period_year number) IS
464: SELECT nvl(sum(nvl(sqa.target * it.ct,0)),0) target
465: from cn_srp_quota_assigns sqa,
466: cn_quotas q,
467: (select count(distinct interval_number) ct, it.interval_type_id
468: from cn_cal_per_int_types it, cn_period_statuses ps
469: where it.cal_period_id = ps.period_id
470: and it.org_id = ps.org_id

Line 489: cn_quotas quota

485: CURSOR rolling_quota_cur IS
486: SELECT nvl(cspq.rollover,0),
487: nvl(cspq.total_rollover,0)
488: FROM cn_srp_period_quotas cspq,
489: cn_quotas quota
490: WHERE cspq.period_id = p_period_id
491: AND cspq.srp_plan_assign_id = p_srp_plan_assign_id
492: AND cspq.quota_id = quota.quota_id
493: AND cspq.org_id = quota.org_id

Line 564: select distinct quota_group_code from cn_quotas_all

560: (p_org_id IN NUMBER,
561: x_result_tbl OUT NOCOPY group_code_tbl_type) IS
562:
563: CURSOR group_codes IS
564: select distinct quota_group_code from cn_quotas_all
565: where quota_group_code is not null
566: and quota_id > 0 and org_id=p_org_id;
567: l_count NUMBER := 1;
568:

Line 609: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q

605: cn_roles r,
606: cn_comp_plans cp,
607: (select spa.srp_plan_assign_id srp_plan_assign_id,
608: nvl(sum(balance2_dtd),0) earnings
609: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q
610: where sp.srp_plan_assign_id = spa.srp_plan_assign_id
611: and sp.salesrep_id = spa.salesrep_id
612: and sp.org_id = spa.org_id
613: and sp.org_id = q.org_id

Line 622: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q

618: and period_id between c_period_start_pd and c_end_pd
619: group by spa.srp_plan_assign_id) inv_ptd ,
620: (select spa.srp_plan_assign_id srp_plan_assign_id,
621: nvl(sum(balance2_dtd),0) earnings
622: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q
623: where sp.srp_plan_assign_id = spa.srp_plan_assign_id
624: and sp.salesrep_id = spa.salesrep_id
625: and sp.org_id = spa.org_id
626: and sp.org_id = q.org_id

Line 724: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q

720: cn_roles r,
721: cn_comp_plans cp,
722: (select spa.srp_plan_assign_id srp_plan_assign_id,
723: nvl(sum(balance2_dtd),0) earnings
724: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q
725: where sp.srp_plan_assign_id = spa.srp_plan_assign_id
726: and sp.salesrep_id = spa.salesrep_id
727: and spa.org_id = p_org_id--and sp.org_id = spa.org_id
728: and q.org_id = p_org_id --and sp.org_id = q.org_id

Line 825: select distinct quota_group_code from cn_quotas_all where quota_group_code is not null

821: ORDER BY assign.start_date;
822:
823: cursor cur_quota_groups
824: is
825: select distinct quota_group_code from cn_quotas_all where quota_group_code is not null
826: and quota_id > 0 and org_id=p_org_id;
827: begin
828: select min(p2.start_date), min(p2.period_id)
829: into l_year_start_date, l_year_start_period

Line 933: from cn_quotas_all

929: cursor quota_groups(c_org_id NUMBER)
930: is
931: select
932: distinct quota_group_code
933: from cn_quotas_all
934: where quota_group_code is not null and quota_id > 0 and org_id=p_org_id;
935:
936: TYPE srp_plan_assigns_type IS TABLE OF srp_plan_assigns%ROWTYPE;
937: srp_plan_assigns_tbl srp_plan_assigns_type;

Line 1052: from cn_quotas_all

1048:
1049: cursor quota_groups(c_org_id NUMBER)
1050: is
1051: select distinct quota_group_code
1052: from cn_quotas_all
1053: where quota_group_code is not null
1054: and quota_id > 0
1055: and org_id = c_org_id;
1056:

Line 1160: cn_quotas_all q

1156: cn_srp_plan_assigns assign,
1157: cn_roles r,
1158: cn_comp_plans cp,
1159: cn_payment_worksheets w,
1160: cn_quotas_all q
1161: WHERE assign.srp_plan_assign_id(+) = srp.srp_plan_assign_id
1162: AND srp.period_id = l_period_id
1163: AND assign.role_id = r.role_id(+)
1164: AND assign.comp_plan_id = cp.comp_plan_id(+)