APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on JTF_RS_ROLES_TL

Line 66: l_role_name jtf_rs_roles_tl.role_name%TYPE;

62: l_org_id NUMBER;
63: l_salesrep_id NUMBER;
64: l_pay_group_id NUMBER;
65: l_salesrep_name cn_salesreps.name%TYPE;
66: l_role_name jtf_rs_roles_tl.role_name%TYPE;
67:
68: BEGIN
69: -- get start_date, end_date org_id and pay_group_id from role_pay_groups
70: select org_id, pay_group_id, start_date, end_date

Line 118: FROM jtf_rs_roles_tl

114: IF(l_start_date is NULL)
115: THEN
116: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
117: SELECT role_name into l_role_name
118: FROM jtf_rs_roles_tl
119: WHERE role_id =
120: (SELECT role_id
121: FROM cn_srp_roles
122: WHERE srp_role_id = p_srp_role_id