APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_TERR_GRP_OWNERS

Line 387: jtf_tty_terr_grp_owners jto

383: BEGIN
384: SELECT 'VALID'
385: INTO l_select
386: FROM jtf_tty_srch_my_resources_v /*jtf_tty_my_resources_v*/ grv,
387: jtf_tty_terr_grp_owners jto
388: WHERE EXISTS
389: ( SELECT NULL
390: FROM JTF_RS_GROUPS_DENORM /*jtf_rs_grp_denorm_vl*/ grpd
391: WHERE /* part of Salesgroup hierarchy of Territory Group owner */

Line 532: , jtf_tty_terr_grp_owners tgo

528: AND mgr.group_id = grpmemo.group_id
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