DBA Data[Home] [Help]

APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_ROLE_PLANS_ALL

Line 837: FROM cn_role_plans_all

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

Line 1591: FROM cn_role_plans_all

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