APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TERR_QUAL_ALL

Line 781: , jtf_terr_qual_all c

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

Line 807: INSERT INTO jtf_terr_qual_all

803: INTO l_terr_qual_id
804: FROM DUAL;
805: --dbms_output.put_line(' AFter select ing from seq qual id');
806:
807: INSERT INTO jtf_terr_qual_all
808: ( TERR_QUAL_ID
809: , LAST_UPDATE_DATE
810: , LAST_UPDATED_BY
811: , CREATION_DATE