APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on CN_COMP_PLANS

Line 328: cn_comp_plans cp

324: assign.start_date start_date,
325: assign.end_date end_date
326: FROM cn_srp_plan_assigns assign,
327: cn_roles r,
328: cn_comp_plans cp
329: WHERE l_year_start_date <= nvl(assign.end_date, l_year_start_date)
330: AND l_period_end_date >= assign.start_date
331: AND assign.role_id = r.role_id
332: AND assign.comp_plan_id = cp.comp_plan_id

Line 606: cn_comp_plans cp,

602: nvl(inv_ptd.earnings,0) ptd_earnings,
603: nvl(inv_ytd.earnings,0) ytd_earnings
604: FROM cn_srp_plan_assigns assign,
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

Line 721: cn_comp_plans cp,

717: assign.salesrep_id salesrep_id,
718: nvl(inv.earnings,0) earnings
719: FROM cn_srp_plan_assigns assign,
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

Line 813: cn_comp_plans cp

809: is
810: SELECT assign.srp_plan_assign_id
811: FROM cn_srp_plan_assigns assign,
812: cn_roles r,
813: cn_comp_plans cp
814: WHERE l_year_start_date <= nvl(assign.end_date, l_year_start_date)
815: AND l_period_end_date >= assign.start_date
816: AND assign.role_id = r.role_id
817: AND assign.comp_plan_id = cp.comp_plan_id

Line 909: cn_comp_plans cp

905: is
906: SELECT assign.srp_plan_assign_id
907: FROM cn_srp_plan_assigns assign,
908: cn_roles r,
909: cn_comp_plans cp
910: WHERE c_year_start_date <= nvl(assign.end_date, c_year_start_date)
911: AND c_period_end_date >= assign.start_date
912: AND assign.role_id = r.role_id
913: AND assign.comp_plan_id = cp.comp_plan_id

Line 1037: cn_comp_plans cp

1033: is
1034: SELECT assign.srp_plan_assign_id
1035: FROM cn_srp_plan_assigns assign,
1036: cn_roles r,
1037: cn_comp_plans cp
1038: WHERE c_year_start_date <= nvl(assign.end_date, c_year_start_date)
1039: AND c_period_end_date >= assign.start_date
1040: AND assign.role_id = r.role_id
1041: AND assign.comp_plan_id = cp.comp_plan_id

Line 1158: cn_comp_plans cp,

1154: q.quota_group_code quota_group_code
1155: FROM cn_srp_periods srp,
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