APPS.AS_COMPETITOR_PROD_PVT dependencies on AS_LEADS

Line 22: as_leads_all ld

18:
19: CURSOR c_WIN_LOSS_INDICATOR(c_LEAD_ID NUMBER) IS
20: select st.WIN_LOSS_INDICATOR
21: from as_statuses_b st,
22: as_leads_all ld
23: where st.STATUS_CODE = ld.STATUS
24: and ld.LEAD_ID = c_LEAD_ID;
25:
26: l_indicator varchar2(1);

Line 354: UPDATE AS_LEADS_ALL

350: END IF;
351:
352: -- rolloup the competitor to the opp header
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 )

Line 1377: FROM as_leads

1373:
1374:
1375: CURSOR C_Lead_Id_Exists (c_Lead_Id NUMBER) IS
1376: SELECT 'X'
1377: FROM as_leads
1378: WHERE lead_id = c_Lead_Id;
1379:
1380: l_val VARCHAR2(1);
1381: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);