DBA Data[Home] [Help]

APPS.JTF_TTY_OVERLAP_WEBADI_PKG dependencies on JTF_TTY_TERR_GROUPS

Line 88: ,jtf_tty_terr_groups TG

84: cursor c_conflicting_TG(c_named_account_id VARCHAR2) is
85: select distinct TG.terr_group_name
86: , TER.name parent_territory
87: from jtf_tty_terr_grp_accts TGA
88: ,jtf_tty_terr_groups TG
89: ,jtf_terr_all TER
90: where TGA.named_account_id = c_named_account_id
91: and TGA.terr_group_id = TG.terr_group_id
92: and TG.parent_terr_id = TER.terr_id