APPS.AS_COMPETITOR_PROD_PVT dependencies on AS_LEADS_ALL

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 )