DBA Data[Home] [Help]

APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TERR_ALL

Line 759: FROM jtf_terr_all

755: terr_id ,
756: org_id
757: INTO l_terr_id_new
758: , l_org_id
759: FROM jtf_terr_all
760: WHERE geo_territory_id = l_g_terr_id ; --its geo_terr_id
761:
762: --dbms_output.put_line(' after selecting terr_id is'||terr_id);
763:

Line 779: jtf_terr_all a

775: c.terr_qual_id
776: INTO
777: l_terr_qual_id
778: FROM
779: jtf_terr_all a
780: , jtf_tty_geo_terr b
781: , jtf_terr_qual_all c
782: WHERE
783: b.geo_territory_id = a.geo_Territory_id