APPS.CSF_TASK_ADDRESS_PVT dependencies on FND_TERRITORIES_TL

Line 731: fnd_territories_tl tl,

727: l.timezone_id
728: FROM jtf_tasks_b t,
729: jtf_task_types_b tt,
730: hz_locations l,
731: fnd_territories_tl tl,
732: jtf_task_statuses_vl jts,
733: csf_sdm_ctry_profiles' || p_dataset || ' cp,
734: csf_spatial_ctry_mappings cm
735: WHERE tt.task_type_id = t.task_type_id

Line 775: fnd_territories_tl tl,

771: FROM jtf_tasks_b t,
772: jtf_task_types_b tt,
773: hz_party_sites hps,
774: hz_locations l,
775: fnd_territories_tl tl,
776: jtf_task_statuses_vl jts,
777: csf_sdm_ctry_profiles' || p_dataset || ' cp,
778: csf_spatial_ctry_mappings cm
779: WHERE tt.task_type_id = t.task_type_id

Line 818: fnd_territories_tl tl,

814: l.timezone_id
815: FROM jtf_tasks_b t,
816: jtf_task_types_b tt,
817: hz_locations l,
818: fnd_territories_tl tl,
819: jtf_task_statuses_vl jts,
820: csf_odf_ctry_mapping coc
821: WHERE tt.task_type_id = t.task_type_id
822: AND t.location_id is not null

Line 860: fnd_territories_tl tl,

856: FROM jtf_tasks_b t,
857: jtf_task_types_b tt,
858: hz_party_sites hps,
859: hz_locations l,
860: fnd_territories_tl tl,
861: jtf_task_statuses_vl jts,
862: csf_odf_ctry_mapping coc
863: WHERE tt.task_type_id = t.task_type_id
864: AND t.address_id is not null

Line 2377: FROM fnd_territories_tl ftt

2373:
2374: CURSOR c_country_code (p_country hz_locations.country%TYPE)
2375: IS
2376: SELECT ftt.territory_code country_code
2377: FROM fnd_territories_tl ftt
2378: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)
2379: AND ftt.language = 'US';
2380:
2381: BEGIN

Line 2617: FROM fnd_territories_tl ftt

2613: l_country hz_locations.country%TYPE;
2614: CURSOR c_country_code (p_country hz_locations.country%TYPE)
2615: IS
2616: SELECT ftt.territory_code country_code
2617: FROM fnd_territories_tl ftt
2618: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)
2619: AND ftt.language = 'US';
2620: BEGIN
2621: -- Standard check for call compatibility