APPS.CN_SRP_PERIODS_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 499: from cn_srp_plan_assigns_all

495: and credit_type_id is not null;
496:
497: CURSOR c_get_spa(l_start_date date) IS
498: select srp_plan_assign_id
499: from cn_srp_plan_assigns_all
500: where salesrep_id = p_salesrep_id
501: AND org_id = l_org_id
502: and role_id = p_role_id
503: and comp_plan_id = p_comp_plan_id

Line 508: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

504: and l_start_date between start_date and nvl(end_date, l_start_date);
505:
506: l_srp_pay_grp_csr c_srp_pay_grp_csr%ROWTYPE;
507: l_quota_csr c_quota_csr%ROWTYPE;
508: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
509:
510: BEGIN
511: -- Standard Start of API savepoint
512: SAVEPOINT Create_Srp_Periods;