DBA Data[Home] [Help]

APPS.AMS_COPYELEMENTS_PVT dependencies on AMS_GEOAREA_SCR_V

Line 672: FROM ams_geoarea_scr_v

668: CURSOR c_geo_source_name(l_location_id NUMBER,
669: l_location_type VARCHAR2) IS
670:
671: SELECT substr(location_name||','||location,1,240)
672: FROM ams_geoarea_scr_v
673: WHERE location_hierarchy_id = l_location_id
674: AND location_type_code = l_location_type;
675: BEGIN
676: p_errcode := NULL;