APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_RS_ROLES_VL

Line 68: FROM jtf_rs_roles_vl rol

64: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
65:
66: CURSOR c_get_role_code ( c_role_name VARCHAR2 ) IS
67: SELECT rol.role_code
68: FROM jtf_rs_roles_vl rol
69: WHERE upper(rol.role_name) = upper(c_role_name)
70: AND ( rol.role_type_code = 'SALES'
71: OR rol.role_type_code = 'TELESALES'
72: OR rol.role_type_code = 'FIELDSALES'

Line 452: FROM jtf_rs_roles_vl rol

448: , MY_GRPS.CURRENT_USER_ID
449: , rol.role_code, rol.role_name
450: , MY_GRPS.current_user_role_code
451: , MY_GRPS.current_user_rsc_id
452: FROM jtf_rs_roles_vl rol
453: , jtf_rs_role_relations rlt
454: , jtf_rs_group_members grpmemo
455: , jtf_rs_resource_extns_vl dir
456:

Line 503: FROM jtf_rs_roles_vl rol

499: , dir.user_id CURRENT_USER_ID
500: , rol.role_code, rol.role_name
501: , rol.role_code current_user_role_code
502: , dir.resource_id current_user_rsc_id
503: FROM jtf_rs_roles_vl rol
504: , jtf_rs_role_relations rlt
505: , jtf_rs_group_members grpmemo
506: , jtf_rs_resource_extns_vl dir
507: , ( /* SALES GROUPS INLINE VIEW */