APPS.JTF_TTY_ALIGN_ACTIVATE_PKG dependencies on JTF_TTY_TERR_GRP_ROLES

Line 84: FROM jtf_tty_terr_grp_roles TGR

80: AND alpa.align_acct_id = alac.align_acct_id
81: AND alac.terr_group_account_id = tga.terr_group_account_id
82: AND alac.alignment_id = c_alignment_id
83: AND NOT EXISTS ( SELECT 'Y'
84: FROM jtf_tty_terr_grp_roles TGR
85: WHERE tgr.role_code = alpt.rsc_role_code
86: AND tgr.terr_group_id = tga.terr_group_id
87: );
88: