APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_RS_RESOURCE_EXTNS

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 470: , jtf_rs_resource_extns mrsc

466: , rol.role_code current_user_role_code
467: FROM jtf_rs_group_usages usg
468: , jtf_rs_groups_denorm dv
469: , jtf_rs_rep_managers sgh
470: , jtf_rs_resource_extns mrsc
471: , jtf_rs_roles_b rol
472: , jtf_rs_role_relations rlt
473: WHERE usg.usage = 'SALES'
474: AND usg.group_id = dv.group_id

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

Line 679: FROM jtf_rs_resource_extns rsc,

675: where mydir.current_user_id = c_user_id );
676:
677: CURSOR c_get_user_id (l_align_id number )
678: IS SELECT rsc.user_id
679: FROM jtf_rs_resource_extns rsc,
680: jtf_tty_alignments al
681: WHERE rsc.resource_id = al.owner_resource_id
682: AND al.owner_resource_type = 'RS_EMPLOYEE'
683: AND al.alignment_id = l_align_id;

Line 854: jtf_rs_resource_extns dir ,

850: WHERE narsc.terr_group_account_id = l_terr_grp_acct_id
851: AND EXISTS (
852: SELECT 'Y'
853: FROM jtf_rs_group_members grpmemo ,
854: jtf_rs_resource_extns dir ,
855: ( SELECT /*+ NO_MERGE */ dv.group_id ,
856: mrsc.user_id CURRENT_USER_ID
857: FROM jtf_rs_group_usages usg ,
858: jtf_rs_groups_denorm dv ,

Line 860: jtf_rs_resource_extns mrsc ,

856: mrsc.user_id CURRENT_USER_ID
857: FROM jtf_rs_group_usages usg ,
858: jtf_rs_groups_denorm dv ,
859: jtf_rs_rep_managers sgh ,
860: jtf_rs_resource_extns mrsc ,
861: jtf_rs_roles_b rol ,
862: jtf_rs_role_relations rlt
863: WHERE usg.usage = 'SALES'
864: AND usg.group_id = dv.group_id

Line 881: jtf_rs_resource_extns dir ,

877: AND grpmemo.group_id = narsc.rsc_group_id
878: UNION ALL
879: SELECT 'Y'
880: FROM jtf_rs_group_members grpmemo ,
881: jtf_rs_resource_extns dir ,
882: jtf_rs_group_usages usg
883: WHERE usg.usage = 'SALES'
884: AND grpmemo.resource_id = dir.resource_id
885: AND grpmemo.group_id = usg.group_id