APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TTY_GEO_GRP_VALUES

Line 105: from jtf_tty_geo_grp_values grpv,

101: select grpv.comparison_operator, grpv.geo_id_from, grpv.geo_id_to,
102: tg.terr_group_name territory_group,
103: pterr.geo_terr_name manager_terr_name,
104: terr.geo_terr_name geo_terr_name
105: from jtf_tty_geo_grp_values grpv,
106: jtf_tty_terr_groups tg,
107: jtf_tty_geo_terr terr,
108: jtf_tty_geo_terr pterr
109: where terr.geo_territory_id =terr_id

Line 127: from jtf_tty_geo_grp_values grpv,

123: g.City_code city,
124: g.postal_code postal_code,
125: null terr_name,
126: g.geo_id geo_id
127: from jtf_tty_geo_grp_values grpv,
128: jtf_tty_terr_groups tg,
129: jtf_tty_geo_terr terr,
130: jtf_tty_geo_terr_rsc rsc,
131: jtf_tty_geographies g --postal_code level

Line 154: from jtf_tty_geo_grp_values grpv,

150: g.City_code city,
151: g.postal_code postal_code,
152: null terr_name,
153: g.geo_id geo_id
154: from jtf_tty_geo_grp_values grpv,
155: jtf_tty_terr_groups tg,
156: jtf_tty_geo_terr terr,
157: jtf_tty_geo_terr_rsc rsc,
158: jtf_tty_geographies g, --postal_code level

Line 184: from jtf_tty_geo_grp_values grpv,

180: g.City_code city,
181: g.postal_code postal_code,
182: null terr_name,
183: g.geo_id geo_id
184: from jtf_tty_geo_grp_values grpv,
185: jtf_tty_terr_groups tg,
186: jtf_tty_geo_terr terr,
187: jtf_tty_geo_terr_rsc rsc,
188: jtf_tty_geographies g,

Line 414: jtf_tty_geo_grp_values grpv,

410: select count(g.postal_code) exist --, terr.geo_territory_id terr_id
411: --grpv.comparison_operator, grpv.geo_type, grpv.geo_id_from, geo_id_to, terr.geo_territory_id terr_id
412: from jtf_tty_geo_terr terr,
413: jtf_tty_geo_terr_rsc rsc,
414: jtf_tty_geo_grp_values grpv,
415: jtf_tty_geographies g
416: where rsc_id = rsc.resource_id
417: and rsc.geo_territory_id = terr.geo_territory_id
418: and terr.owner_resource_id <0

Line 429: from jtf_tty_geo_grp_values grpv,

425: and g.postal_code = p_pc
426:
427: union
428: select count(g.postal_code) exist /* postal code range*/
429: from jtf_tty_geo_grp_values grpv,
430: jtf_tty_terr_groups tg,
431: jtf_tty_geo_terr terr,
432: jtf_tty_geo_terr_rsc rsc,
433: jtf_tty_geographies g, --postal_code level

Line 455: jtf_tty_geo_grp_values grpv,

451: union
452: select count(g.postal_code) exist
453: from jtf_tty_geo_terr terr,
454: jtf_tty_geo_terr_rsc rsc,
455: jtf_tty_geo_grp_values grpv,
456: jtf_tty_geographies g,
457: jtf_tty_geographies g1
458: where rsc_id = rsc.resource_id
459: and rsc.geo_territory_id = terr.geo_territory_id