APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TTY_GEO_GRP_VALUES

Line 913: /* Fix for the bug 3135657. Added jtf_tty_geo_grp_values */

909: AND ga.named_account_id = a.named_account_id
910: AND g.terr_group_id = TERR_GROUP.TERR_GROUP_ID
911: AND ROWNUM < 2;
912: else
913: /* Fix for the bug 3135657. Added jtf_tty_geo_grp_values */
914:
915: /* does Territory Group have at least 1 Geo Territory ? */
916: SELECT COUNT(*)
917: INTO l_na_count

Line 919: , jtf_tty_geo_grp_values gterr

915: /* does Territory Group have at least 1 Geo Territory ? */
916: SELECT COUNT(*)
917: INTO l_na_count
918: from jtf_tty_terr_groups tgrp
919: , jtf_tty_geo_grp_values gterr
920: where tgrp.terr_group_id = gterr.terr_group_id
921: AND ROWNUM < 2;
922:
923: end if;

Line 3842: from jtf_tty_geo_grp_values grpv,

3838: /* postal code */
3839: select g.postal_code postal_code,
3840: g.geo_id geo_id
3841: , terr.geo_territory_id
3842: from jtf_tty_geo_grp_values grpv,
3843: jtf_tty_terr_groups tg,
3844: jtf_tty_geo_terr terr,
3845: jtf_tty_geographies g --postal_code level
3846: where terr.terr_group_id = tg.terr_group_id

Line 3868: from jtf_tty_geo_grp_values grpv,

3864: union
3865: select g.postal_code postal_code,
3866: g.geo_id geo_id
3867: , terr.geo_territory_id
3868: from jtf_tty_geo_grp_values grpv,
3869: jtf_tty_terr_groups tg,
3870: jtf_tty_geo_terr terr,
3871: jtf_tty_geographies g,
3872: jtf_tty_geographies g1