APPS.EGO_ITEM_AML_PUB dependencies on MTL_MANUFACTURERS

Line 1274: l_mfg_name mtl_manufacturers.manufacturer_name%TYPE;

1270: l_api_version NUMBER;
1271: l_api_name VARCHAR2(50);
1272: l_return_status VARCHAR2(1);
1273: l_message_name VARCHAR2(30);
1274: l_mfg_name mtl_manufacturers.manufacturer_name%TYPE;
1275:
1276: BEGIN
1277: l_api_version := 1.0;
1278: l_api_name := 'CHECK_NO_MFG_ASSOCIATIONS';

Line 1344: FROM mtl_manufacturers

1340: IF l_message_name IS NOT NULL THEN
1341: BEGIN
1342: SELECT manufacturer_name
1343: INTO l_mfg_name
1344: FROM mtl_manufacturers
1345: WHERE manufacturer_id = p_manufacturer_id;
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: l_mfg_name := NULL;