APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_ROLE_PLANS

Line 604: -- Desc : check if the record is valid to delete from cn_role_plans

600:
601:
602: -- ----------------------------------------------------------------------------*
603: -- Procedure: check_valid_delete
604: -- Desc : check if the record is valid to delete from cn_role_plans
605: -- called in delete_role_plan before deleting a role
606: -- ----------------------------------------------------------------------------*
607: PROCEDURE check_valid_delete
608: (

Line 700: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,

696: -- Procedure: srp_plan_assignment_for_delete
697: -- --------------------------------------------------------------------------*
698: PROCEDURE srp_plan_assignment_for_delete
699: (p_role_id IN cn_roles.role_id%TYPE,
700: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
701: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
702: p_org_id IN cn_salesreps.org_id%TYPE,
703: x_return_status OUT NOCOPY VARCHAR2,
704: p_loading_status IN VARCHAR2,

Line 789: CURSOR get_role_plans(p_role_id cn_roles.role_id%TYPE,p_org_id cn_role_plans.org_id%TYPE) IS

785: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date,org_id
786: FROM cn_srp_roles
787: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
788:
789: CURSOR get_role_plans(p_role_id cn_roles.role_id%TYPE,p_org_id cn_role_plans.org_id%TYPE) IS
790: SELECT role_plan_id
791: FROM cn_role_plans
792: WHERE role_id = p_role_id and org_id=p_org_id;
793:

Line 791: FROM cn_role_plans

787: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
788:
789: CURSOR get_role_plans(p_role_id cn_roles.role_id%TYPE,p_org_id cn_role_plans.org_id%TYPE) IS
790: SELECT role_plan_id
791: FROM cn_role_plans
792: WHERE role_id = p_role_id and org_id=p_org_id;
793:
794: CURSOR get_plan_assigns
795: (p_role_id NUMBER,

Line 1166: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_plans.org_id%TYPE) IS

1162: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
1163:
1164: --Changed the cursor to fetch role_plans for the role_id passed
1165:
1166: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_plans.org_id%TYPE) IS
1167: SELECT role_plan_id,role_id
1168: FROM cn_role_plans
1169: WHERE role_id =l_role_id and org_id=l_org_id;
1170:

Line 1168: FROM cn_role_plans

1164: --Changed the cursor to fetch role_plans for the role_id passed
1165:
1166: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_plans.org_id%TYPE) IS
1167: SELECT role_plan_id,role_id
1168: FROM cn_role_plans
1169: WHERE role_id =l_role_id and org_id=l_org_id;
1170:
1171: CURSOR get_plan_assigns
1172: (p_role_id NUMBER,