375: -- Procedure: srp_plan_assignment_for_delete
376: -- --------------------------------------------------------------------------*
377: PROCEDURE srp_plan_assignment_for_delete
378: (p_role_id IN cn_roles.role_id%TYPE,
379: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
380: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
381: p_org_id IN cn_salesreps.org_id%TYPE,
382: x_return_status OUT NOCOPY VARCHAR2,
383: p_loading_status IN VARCHAR2,
507: AND org_id = p_paygroup_assign_rec.org_id;
508:
509: CURSOR get_role_plans(p_role_id NUMBER) IS
510: SELECT role_plan_id
511: FROM cn_role_plans
512: WHERE role_id = p_role_id
513: AND org_id = p_paygroup_assign_rec.org_id;
514:
515: CURSOR get_plan_assigns
833: AND org_id = p_paygroup_assign_rec.org_id;
834:
835: CURSOR get_role_plans(p_role_id NUMBER) IS
836: SELECT role_plan_id
837: FROM cn_role_plans_all
838: WHERE role_id = p_role_id
839: AND org_id = p_paygroup_assign_rec.org_id;
840:
841: CURSOR get_plan_assigns
1587: l_paygroup_assign_rec paygroup_assign_rec;
1588:
1589: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE) IS
1590: SELECT role_plan_id,role_id
1591: FROM cn_role_plans_all
1592: WHERE role_id = l_role_id
1593: AND org_id = p_paygroup_assign_rec.org_id;
1594:
1595: CURSOR get_salesreps(l_role_id NUMBER) IS