APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 55: FROM jtf_rs_resource_extns_vl

51: l_res_tbl NUMBER_TABLE_TYPE := NUMBER_TABLE_TYPE();
52:
53: CURSOR c_get_resource_id ( c_resource_name VARCHAR2 ) IS
54: SELECT RESOURCE_id
55: FROM jtf_rs_resource_extns_vl
56: WHERE upper(resource_name) = upper(c_resource_name)
57: AND category = 'EMPLOYEE'
58: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
59:

Line 455: , jtf_rs_resource_extns_vl dir

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:
457: , ( /* MY_GRPS INLINE VIEW */
458: /* Groups logged-in user manages/administrates */
459: SELECT /*+ NO_MERGE */

Line 506: , jtf_rs_resource_extns_vl dir

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 */
508: SELECT dv.group_id
509: , dv.group_id PARENT_GROUP_ID
510: , NULL PARENT_GROUP_NAME