APPS.CN_SRP_PLAN_ASSIGNS_PVT dependencies on CN_ROLE_PLANS

Line 28: l_role_plans_row cn_role_plans%ROWTYPE;

24: IS
25: l_api_name CONSTANT VARCHAR2(30) := 'valid_srp_plan_assign';
26: l_dummy NUMBER;
27: l_srp_roles_row cn_srp_roles%ROWTYPE;
28: l_role_plans_row cn_role_plans%ROWTYPE;
29: l_srp_pay_grp_sd cn_srp_pay_groups.start_date%TYPE;
30: l_srp_pay_grp_ed cn_srp_pay_groups.end_date%TYPE;
31: l_spg_max_sd cn_srp_pay_groups.start_date%TYPE;
32: l_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE;

Line 44: FROM cn_role_plans

40: -- Check if Comp Plan does assign to the sales role
41: BEGIN
42: SELECT *
43: INTO l_role_plans_row
44: FROM cn_role_plans
45: WHERE role_plan_id = p_role_plan_id;
46: EXCEPTION
47: WHEN NO_DATA_FOUND THEN
48: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN