APPS.CN_SRP_PLAN_ASSIGNS_PVT dependencies on CN_SRP_ROLES

Line 27: l_srp_roles_row cn_srp_roles%ROWTYPE;

23: )
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;

Line 64: FROM cn_srp_roles

60: -- Check if Role does assign to the salesrep
61: BEGIN
62: SELECT *
63: INTO l_srp_roles_row
64: FROM cn_srp_roles
65: WHERE srp_role_id = p_srp_role_id
66: AND org_id = l_role_plans_row.org_id; --MOAC
67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN