APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_ROLE_PLANS

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

623:
624:
625: -- ----------------------------------------------------------------------------*
626: -- Procedure: check_valid_delete
627: -- Desc : check if the record is valid to delete from cn_role_plans
628: -- called in delete_role_plan before deleting a role
629: -- ----------------------------------------------------------------------------*
630: PROCEDURE check_valid_delete
631: (

Line 723: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,

719: -- Procedure: srp_plan_assignment_for_delete
720: -- --------------------------------------------------------------------------*
721: PROCEDURE srp_plan_assignment_for_delete
722: (p_role_id IN cn_roles.role_id%TYPE,
723: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
724: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
725: p_org_id IN cn_salesreps.org_id%TYPE,
726: x_return_status OUT NOCOPY VARCHAR2,
727: p_loading_status IN VARCHAR2,

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

821: AND
822: ((end_Date_active is null)
823: OR (end_Date_active IS NOT NULL AND end_Date_active BETWEEN p_role_pay_groups_rec.start_date AND p_role_pay_groups_rec.end_date));
824:
825: CURSOR get_role_plans(p_role_id cn_roles.role_id%TYPE,p_org_id cn_role_plans.org_id%TYPE) IS
826: SELECT role_plan_id
827: FROM cn_role_plans
828: WHERE role_id = p_role_id and org_id=p_org_id;
829:

Line 827: FROM cn_role_plans

823: OR (end_Date_active IS NOT NULL AND end_Date_active BETWEEN p_role_pay_groups_rec.start_date AND p_role_pay_groups_rec.end_date));
824:
825: CURSOR get_role_plans(p_role_id cn_roles.role_id%TYPE,p_org_id cn_role_plans.org_id%TYPE) IS
826: SELECT role_plan_id
827: FROM cn_role_plans
828: WHERE role_id = p_role_id and org_id=p_org_id;
829:
830: CURSOR get_plan_assigns
831: (p_role_id NUMBER,

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

1212: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
1213:
1214: --Changed the cursor to fetch role_plans for the role_id passed
1215:
1216: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_plans.org_id%TYPE) IS
1217: SELECT role_plan_id,role_id
1218: FROM cn_role_plans
1219: WHERE role_id =l_role_id and org_id=l_org_id;
1220:

Line 1218: FROM cn_role_plans

1214: --Changed the cursor to fetch role_plans for the role_id passed
1215:
1216: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_plans.org_id%TYPE) IS
1217: SELECT role_plan_id,role_id
1218: FROM cn_role_plans
1219: WHERE role_id =l_role_id and org_id=l_org_id;
1220:
1221: CURSOR get_plan_assigns
1222: (p_role_id NUMBER,