APPS.CSF_TASK_ADDRESS_PVT dependencies on FND_TERRITORIES_TL

Line 416: fnd_territories_tl tl,

412: l.timezone_id
413: FROM jtf_tasks_b t,
414: jtf_task_types_b tt,
415: hz_locations l,
416: fnd_territories_tl tl,
417: jtf_task_statuses_vl jts
418: WHERE tt.task_type_id = t.task_type_id
419: AND t.location_id is not null
420: AND l.location_id = t.location_id

Line 451: fnd_territories_tl tl,

447: FROM jtf_tasks_b t,
448: jtf_task_types_b tt,
449: hz_party_sites hps,
450: hz_locations l,
451: fnd_territories_tl tl,
452: jtf_task_statuses_vl jts
453: WHERE tt.task_type_id = t.task_type_id
454: AND t.address_id is not null
455: AND t.address_id = hps.party_site_id

Line 488: fnd_territories_tl tl,

484: l.timezone_id
485: FROM jtf_tasks_b t,
486: jtf_task_types_b tt,
487: hz_locations l,
488: fnd_territories_tl tl,
489: jtf_task_statuses_vl jts,
490: CSF_SPATIAL_CTRY_MAPPINGS sp
491: WHERE tt.task_type_id = t.task_type_id
492: AND t.location_id is not null

Line 526: fnd_territories_tl tl,

522: FROM jtf_tasks_b t,
523: jtf_task_types_b tt,
524: hz_party_sites hps,
525: hz_locations l,
526: fnd_territories_tl tl,
527: jtf_task_statuses_vl jts,
528: CSF_SPATIAL_CTRY_MAPPINGS sp
529: WHERE tt.task_type_id = t.task_type_id
530: AND t.address_id is not null

Line 1930: FROM fnd_territories_tl ftt

1926:
1927: CURSOR c_country_code (p_country hz_locations.country%TYPE)
1928: IS
1929: SELECT ftt.territory_code country_code
1930: FROM fnd_territories_tl ftt
1931: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)
1932: AND ftt.language = 'US';
1933:
1934: BEGIN

Line 2163: FROM fnd_territories_tl ftt

2159: l_country hz_locations.country%TYPE;
2160: CURSOR c_country_code (p_country hz_locations.country%TYPE)
2161: IS
2162: SELECT ftt.territory_code country_code
2163: FROM fnd_territories_tl ftt
2164: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)
2165: AND ftt.language = 'US';
2166: BEGIN
2167: -- Standard check for call compatibility