APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 234: cn_srp_plan_assigns_all cspa,

230: SELECT SUM(Decode(cl.pending_status, 'Y', 0,
231: cl.commission_amount)) bonus_earned_ptd
232: FROM cn_commission_lines_all cl,
233: cn_commission_headers_all ch,
234: cn_srp_plan_assigns_all cspa,
235: cn_role_plans_all crp,
236: cn_quotas_all cq
237: WHERE cl.credited_salesrep_id = l_salesrep_id
238: AND cl.org_id = g_org_id

Line 678: from cn_srp_plan_assigns_all

674: ||p_srp_pe_subledger.srp_plan_assign_id|| ' and quota_id='||p_srp_pe_subledger.quota_id);
675: end if;
676:
677: select org_id into g_org_id
678: from cn_srp_plan_assigns_all
679: where srp_plan_assign_id = p_srp_pe_subledger.srp_plan_assign_id;
680:
681: -- get the max period in this interval
682: