APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_TERR_GRP_ACCTS

Line 163: FROM jtf_tty_terr_grp_accts tga,

159: FOR i IN 1 .. l_res_tbl.COUNT
160: LOOP
161: BEGIN
162: SELECT 'VALID' INTO l_select
163: FROM jtf_tty_terr_grp_accts tga,
164: jtf_tty_named_acct_rsc nar
165: WHERE nar.terr_group_account_id = tga.terr_group_account_id
166: AND nar.rsc_role_code = X_ROLE_CODE
167: AND nar.resource_id = l_res_tbl(i)

Line 820: FROM jtf_tty_terr_grp_accts

816:
817: /* a change of l_terr_grp_acct_id will be caught here */
818: SELECT named_account_id
819: INTO l_named_account_id
820: FROM jtf_tty_terr_grp_accts
821: WHERE terr_group_account_id = l_terr_grp_acct_id;
822:
823: exception
824: when others then