APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TTY_GEO_TERR_RSC

Line 130: jtf_tty_geo_terr_rsc rsc,

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
132: where
133: rsc.resource_id = l_rsc_id -- user works in this geo terr
134: and rsc.geo_territory_id = terr.geo_territory_id

Line 157: jtf_tty_geo_terr_rsc rsc,

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
159: jtf_tty_geographies g1,
160: jtf_tty_geographies g2
161: where

Line 187: jtf_tty_geo_terr_rsc rsc,

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,
189: jtf_tty_geographies g1
190: where
191: rsc.resource_id = l_rsc_id -- user works in this geo terr

Line 246: jtf_tty_geo_terr_rsc rsc,

242: null terr_name,
243: g.geo_id geo_id
244: from jtf_tty_terr_groups tg,
245: jtf_tty_geo_terr terr,
246: jtf_tty_geo_terr_rsc rsc,
247: jtf_tty_geographies g,
248: jtf_tty_geo_terr_values tv
249: where
250: rsc.resource_id = l_rsc_id

Line 405: jtf_tty_geo_terr_rsc rsc,

401: CURSOR CheckPCInDefTerr(rsc_id IN NUMBER, p_pc varchar2) IS
402: select count(g.postal_code) exist --, terr.geo_territory_id terr_id
403: --grpv.comparison_operator, grpv.geo_type, grpv.geo_id_from, geo_id_to, terr.geo_territory_id terr_id
404: from jtf_tty_geo_terr terr,
405: jtf_tty_geo_terr_rsc rsc,
406: jtf_tty_geo_grp_values grpv,
407: jtf_tty_geographies g
408: where rsc_id = rsc.resource_id
409: and rsc.geo_territory_id = terr.geo_territory_id

Line 424: jtf_tty_geo_terr_rsc rsc,

420: select count(g.postal_code) exist /* postal code range*/
421: from jtf_tty_geo_grp_values grpv,
422: jtf_tty_terr_groups tg,
423: jtf_tty_geo_terr terr,
424: jtf_tty_geo_terr_rsc rsc,
425: jtf_tty_geographies g, --postal_code level
426: jtf_tty_geographies g1,
427: jtf_tty_geographies g2
428: where

Line 446: jtf_tty_geo_terr_rsc rsc,

442: AND g.geo_name BETWEEN g1.geo_name and g2.geo_name
443: union
444: select count(g.postal_code) exist
445: from jtf_tty_geo_terr terr,
446: jtf_tty_geo_terr_rsc rsc,
447: jtf_tty_geo_grp_values grpv,
448: jtf_tty_geographies g,
449: jtf_tty_geographies g1
450: where rsc_id = rsc.resource_id

Line 552: jtf_tty_geo_terr_rsc rsc,

548: -- check if a regular terr the user working on has the postal code.
549: select terr.geo_territory_id into terr_id
550: from jtf_tty_geo_terr terr,
551: jtf_tty_geo_terr_values terrv,
552: jtf_tty_geo_terr_rsc rsc,
553: jtf_tty_geographies geog
554: where terr.geo_territory_id = terrv.geo_territory_id
555: and terrv.geo_id = geog.geo_id
556: and geog.postal_code = p_postal_code /* the PC is in the terr she works in */