APPS.JTF_TTY_WEBADI_NADOC_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 160: FROM jtf_rs_resource_extns_vl rsc

156: , grp.group_name group_name
157: , rsc.resource_id resource_id
158: , grp.group_id group_id
159: , rol.role_code role_code
160: FROM jtf_rs_resource_extns_vl rsc
161: , jtf_rs_groups_vl grp
162: , jtf_rs_roles_vl rol
163: , jtf_tty_named_acct_rsc narsc
164: , jtf_tty_terr_grp_accts ga

Line 232: SELECT resource_id INTO salesMgr FROM jtf_rs_resource_extns

228: --end if;
229:
230: BEGIN
231:
232: SELECT resource_id INTO salesMgr FROM jtf_rs_resource_extns
233: WHERE user_id = TO_NUMBER(p_userid);
234:
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN

Line 692: ' jtf_rs_resource_extns dir , ' ||

688: '( SELECT dir.resource_id, ' ||
689: ' MY_GRPS.group_id , ' ||
690: ' MY_GRPS.CURRENT_USER_ID ' ||
691: ' FROM jtf_rs_group_members grpmemo , ' ||
692: ' jtf_rs_resource_extns dir , ' ||
693: ' ( SELECT /*+ NO_MERGE */ dv.group_id , ' ||
694: ' mrsc.user_id CURRENT_USER_ID ' ||
695: ' FROM jtf_rs_group_usages usg , ' ||
696: 'jtf_rs_groups_denorm dv , ' ||

Line 698: 'jtf_rs_resource_extns mrsc , ' ||

694: ' mrsc.user_id CURRENT_USER_ID ' ||
695: ' FROM jtf_rs_group_usages usg , ' ||
696: 'jtf_rs_groups_denorm dv , ' ||
697: 'jtf_rs_rep_managers sgh , '||
698: 'jtf_rs_resource_extns mrsc , ' ||
699: 'jtf_rs_roles_b rol , ' ||
700: 'jtf_rs_role_relations rlt ' ||
701: ' WHERE usg.usage = ''SALES'' ' ||
702: ' AND usg.group_id = dv.group_id ' ||

Line 718: ' jtf_rs_resource_extns dir , ' ||

714: ' SELECT dir.resource_id , '||
715: ' grpmemo.group_id , ' ||
716: ' dir.user_id CURRENT_USER_ID ' ||
717: ' FROM jtf_rs_group_members grpmemo , ' ||
718: ' jtf_rs_resource_extns dir , ' ||
719: ' jtf_rs_group_usages usg ' ||
720: ' WHERE usg.usage = ''SALES'' ' ||
721: ' AND grpmemo.resource_id = dir.resource_id ' ||
722: ' AND grpmemo.group_id = usg.group_id ' ||

Line 852: ' jtf_rs_resource_extns rsc1 '||

848: ELSE
849: l_na_query := l_na_query ||
850: '( select narsc1.terr_group_account_id '||
851: ' from jtf_tty_named_acct_rsc narsc1, '||
852: ' jtf_rs_resource_extns rsc1 '||
853: ' where narsc1.resource_id = rsc1.resource_id '||
854: ' and narsc1.assigned_flag = ''N'' '||
855: ' and rsc1.user_id = :P_USERID ';
856: END IF; -- end of isAdmin

Line 891: ' jtf_rs_resource_extns rsc1 '||

887: ELSE
888: l_na_query := l_na_query ||
889: ' and not exists ( select ''Y'' '||
890: ' from jtf_tty_named_acct_rsc narsc1, '||
891: ' jtf_rs_resource_extns rsc1 '||
892: ' where narsc1.resource_id = rsc1.resource_id '||
893: ' and narsc1.terr_group_account_id = narsc.terr_group_account_id '||
894: ' and narsc1.assigned_flag = ''N'' '||
895: ' and rsc1.user_id = :P_USERID ';