[Home] [Help]
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
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
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
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
1151: cp.comp_plan_id comp_plan_id,
1152: assign.start_date start_date,
1153: assign.end_date end_date,
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,