APPS.AS_COMPETITOR_PROD_PVT dependencies on AMS_COMPETITOR_PRODUCTS_B

Line 357: from ams_competitor_products_b

353: IF l_loop_count = 1 THEN
354: UPDATE AS_LEADS_ALL
355: SET object_version_number = nvl(object_version_number,0) + 1, CLOSE_COMPETITOR_ID =
356: ( select competitor_party_id
357: from ams_competitor_products_b
358: where competitor_product_id = l_competitor_prod_rec.COMPETITOR_PRODUCT_ID )
359: WHERE lead_id = l_competitor_prod_rec.LEAD_ID
360: AND CLOSE_COMPETITOR_ID is null;
361: END IF;

Line 1246: from ams_competitor_products_b

1242:
1243: /*
1244: CURSOR c_competitor_product_exists(c_COMPETITOR_PRODUCT_ID number) IS
1245: select 'X'
1246: from ams_competitor_products_b
1247: where competitor_product_id = c_COMPETITOR_PRODUCT_ID;
1248: */
1249: l_val VARCHAR2(1);
1250: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);