APPS.JTF_TTY_ALIGN_ACTIVATE_PKG dependencies on JTF_TTY_TERR_GROUPS

Line 57: jtf_tty_terr_groups ttygrp,

53: WHERE aa.alignment_id = c_alignment_id
54: AND aa.terr_group_account_id NOT IN
55: ( SELECT ga.terr_group_account_id
56: FROM jtf_tty_terr_grp_accts ga,
57: jtf_tty_terr_groups ttygrp,
58: jtf_tty_named_acct_rsc narsc,
59: jtf_tty_srch_my_resources_v repdn
60: WHERE ttygrp.terr_group_id = ga.terr_group_id
61: AND ttygrp.active_from_date <= sysdate