APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_GEO_TERR_VALUES

Line 574: DELETE from JTF_TTY_GEO_TERR_VALUES

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

Line 760: DELETE from JTF_TTY_GEO_TERR_VALUES gtv

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

Line 909: DELETE from JTF_TTY_GEO_TERR_VALUES gtv

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

Line 923: DELETE from JTF_TTY_GEO_TERR_VALUES gtv

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