APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_TERR_GRP_ROLES

Line 242: FROM jtf_tty_terr_grp_roles

238: -- check the role code
239: BEGIN
240: SELECT 'Y'
241: INTO l_select
242: FROM jtf_tty_terr_grp_roles
243: WHERE terr_group_id=P_terr_group_id
244: AND role_code = X_ROLE_CODE;
245:
246: EXCEPTION

Line 533: , jtf_tty_terr_grp_roles tgr

529: AND mgr.hierarchy_type = 'MGR_TO_MGR'
530: )
531: ) MY_REPS
532: , jtf_tty_terr_grp_owners tgo
533: , jtf_tty_terr_grp_roles tgr
534: WHERE EXISTS (
535: SELECT NULL
536: FROM JTF_RS_GROUPS_DENORM /*jtf_rs_grp_denorm_vl*/ grpd
537: WHERE grpd.parent_group_id = TGO.rsc_group_id