APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TERR_QUAL_ALL

Line 761: , jtf_terr_qual_all c

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
764: AND b.geo_territory_id = l_g_terr_id --its geo_terr_id
765: AND c.terr_id = a.terr_id

Line 787: INSERT INTO jtf_terr_qual_all

783: INTO l_terr_qual_id
784: FROM DUAL;
785: --dbms_output.put_line(' AFter select ing from seq qual id');
786:
787: INSERT INTO jtf_terr_qual_all
788: ( TERR_QUAL_ID
789: , LAST_UPDATE_DATE
790: , LAST_UPDATED_BY
791: , CREATION_DATE