APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_GEO_TERR_VALUES

Line 576: DELETE from JTF_TTY_GEO_TERR_VALUES

572:
573: /* delete the geos or postal code belonging to the geo territores of this
574: /* geo territory group */
575:
576: DELETE from JTF_TTY_GEO_TERR_VALUES
577: WHERE geo_territory_id IN
578: (SELECT t.geo_territory_id
579: FROM jtf_tty_geo_terr t
580: WHERE t.terr_group_id = p_terr_gp_id);

Line 762: DELETE from JTF_TTY_GEO_TERR_VALUES gtv

758: */
759: PROCEDURE delete_geos_from_terrs(p_terr_gp_id IN NUMBER)
760: AS
761: BEGIN
762: DELETE from JTF_TTY_GEO_TERR_VALUES gtv
763: WHERE gtv.geo_territory_id IN
764: (SELECT geo_territory_id FROM jtf_tty_geo_terr
765: where terr_group_id = p_terr_gp_id)
766: AND gtv.geo_id NOT IN

Line 911: DELETE from JTF_TTY_GEO_TERR_VALUES gtv

907: AS
908: BEGIN
909: /* Delete goes for the geo terrs assigned by the given resource and down
910: * from the given territory */
911: DELETE from JTF_TTY_GEO_TERR_VALUES gtv
912: WHERE gtv.geo_territory_id IN
913: (SELECT gt.geo_territory_id
914: FROM JTF_TTY_GEO_TERR gt
915: START WITH gt.geo_territory_id IN

Line 925: DELETE from JTF_TTY_GEO_TERR_VALUES gtv

921: AND gt1.parent_geo_terr_id = p_territory_id)
922: CONNECT BY PRIOR gt.geo_territory_id = gt.parent_geo_terr_id);
923: /* Delete goes for the geo terrs created by the given resource
924: * from the given territory */
925: DELETE from JTF_TTY_GEO_TERR_VALUES gtv
926: WHERE gtv.geo_territory_id IN
927: (SELECT gt1.geo_territory_id
928: FROM JTF_TTY_GEO_TERR gt1
929: WHERE gt1.owner_resource_id = p_resource_id