APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_RS_ROLES_VL

Line 1046: FROM jtf_rs_roles_vl rol

1042: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
1043:
1044: CURSOR c_get_role_code ( c_role_name VARCHAR2 ) IS
1045: SELECT rol.role_code
1046: FROM jtf_rs_roles_vl rol
1047: WHERE upper(rol.role_name) = upper(c_role_name)
1048: AND (rol.role_type_code = 'SALES' OR
1049: rol.role_type_code = 'TELESALES' OR
1050: rol.role_type_code = 'FIELDSALES')