APPS.CSF_TASK_ADDRESS_PVT dependencies on CSF_SPATIAL_CTRY_MAPPINGS

Line 490: CSF_SPATIAL_CTRY_MAPPINGS sp

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
493: AND l.location_id = t.location_id
494: AND tl.territory_code = l.country

Line 528: CSF_SPATIAL_CTRY_MAPPINGS sp

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
531: AND t.address_id = hps.party_site_id
532: AND l.location_id = hps.location_id

Line 915: FROM CSF_SPATIAL_CTRY_MAPPINGS

911:
912: l_country VARCHAR2(100);
913: CURSOR ctry_hr_to_spatial IS
914: SELECT SPATIAL_COUNTRY_NAME
915: FROM CSF_SPATIAL_CTRY_MAPPINGS
916: WHERE HR_COUNTRY_NAME = p_task_rec.country;
917:
918: BEGIN
919: -- Standard check for call compatibility

Line 1537: FROM CSF_SPATIAL_CTRY_MAPPINGS

1533:
1534: l_country VARCHAR2(100);
1535: CURSOR ctry_hr_to_spatial IS
1536: SELECT SPATIAL_COUNTRY_NAME
1537: FROM CSF_SPATIAL_CTRY_MAPPINGS
1538: WHERE HR_COUNTRY_NAME = upper(p_country);
1539:
1540:
1541: BEGIN