DBA Data[Home] [Help]

APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TERR_ALL

Line 739: FROM jtf_terr_all

735: terr_id ,
736: org_id
737: INTO l_terr_id_new
738: , l_org_id
739: FROM jtf_terr_all
740: WHERE geo_territory_id = l_g_terr_id ; --its geo_terr_id
741:
742: --dbms_output.put_line(' after selecting terr_id is'||terr_id);
743:

Line 759: jtf_terr_all a

755: c.terr_qual_id
756: INTO
757: l_terr_qual_id
758: FROM
759: jtf_terr_all a
760: , jtf_tty_geo_terr b
761: , jtf_terr_qual_all c
762: WHERE
763: b.geo_territory_id = a.geo_Territory_id