APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_MY_DIRECTS_V

Line 269: FROM JTF_TTY_MY_DIRECTS_V

265: -- where clauses for alignment is validating resource as a immediate direct of
266: -- territory group owner rather than alignment owner
267: SELECT 'VALID'
268: INTO l_select
269: FROM JTF_TTY_MY_DIRECTS_V
270: WHERE current_user_id = l_user_id
271: AND resource_id = l_res_tbl(i)
272: AND group_id = X_GROUP_ID
273: AND role_code = X_ROLE_CODE;

Line 333: FROM JTF_TTY_MY_DIRECTS_V

329: -- where clauses for alignment is validating resource as a immediate direct of
330: -- territory group owner rather than alignment owner
331: SELECT resource_id, group_id, role_code
332: INTO x_RESOURCE_id, x_group_id, x_role_code
333: FROM JTF_TTY_MY_DIRECTS_V
334: WHERE current_user_id = l_user_id
335: AND upper(resource_name) = upper(P_RESOURCE_NAME)
336: AND upper(group_name) = upper(P_GROUP_NAME)
337: AND upper(role_name) = upper(P_ROLE_NAME)

Line 698: FROM jtf_tty_my_directs_v

694:
695: CURSOR c_check_direct_res( c_resource_id NUMBER, c_group_id NUMBER,
696: c_role_code VARCHAR2, c_user_id NUMBER )
697: IS SELECT 'Y'
698: FROM jtf_tty_my_directs_v
699: WHERE current_user_id = c_user_id
700: AND resource_id = c_resource_id
701: AND group_id = c_group_id
702: AND role_code = c_role_code;

Line 708: FROM jtf_tty_my_directs_v mydir

704: CURSOR c_get_direct_res( c_resource_id NUMBER, c_group_id NUMBER, c_user_id NUMBER )
705: IS SELECT mydir.resource_id resource_id,
706: mydir.group_id group_id,
707: mydir.role_code role_code
708: FROM jtf_tty_my_directs_v mydir
709: WHERE mydir.current_user_id = c_user_id
710: AND mydir.dir_user_id <> c_user_id
711: AND ( mydir.resource_id, mydir.group_id, mydir.role_code) IN
712: ( SELECT /*+ NO_MERGE */