APPS.AS_OPP_LINE_PVT dependencies on AS_LEADS_ALL

Line 53: UPDATE as_leads_all

49: FETCH C_renue_opp_forst_tot into l_tot_revenue_opp_forecast_amt;
50: CLOSE C_renue_opp_forst_tot;
51: -- End Added for ASNB
52:
53: UPDATE as_leads_all
54: SET total_amount = nvl(l_line_total, 0),
55: TOTAL_REVENUE_OPP_FORECAST_AMT = l_tot_revenue_opp_forecast_amt, -- Added for ASNB
56: last_update_date = SYSDATE,
57: last_updated_by = FND_GLOBAL.USER_ID,

Line 173: From as_leads_all lead, as_statuses_vl status

169: Select lead.win_probability, status.win_loss_indicator,
170: status.forecast_rollup_flag
171: Into l_win_probability, l_win_loss_indicator,
172: l_forecast_rollup_flag
173: From as_leads_all lead, as_statuses_vl status
174: Where lead_id = p_lead_id
175: And lead.status = status.status_code(+);
176: IF l_line_amount_old <> 0 THEN
177: FOR sc_rec In C_sales_credits(p_lead_line_id) LOOP

Line 732: from as_leads_all

728: WHERE LEAD_ID = c_LEAD_ID;
729:
730: CURSOR c_decision_date(c_lead_id NUMBER) IS
731: select decision_date
732: from as_leads_all
733: where lead_id = c_lead_id;
734:
735: CURSOR c_lead_org_id(p_lead_id NUMBER) IS
736: select org_id

Line 737: from as_leads_all

733: where lead_id = c_lead_id;
734:
735: CURSOR c_lead_org_id(p_lead_id NUMBER) IS
736: select org_id
737: from as_leads_all
738: where lead_id = p_lead_id;
739:
740:
741: CURSOR c_campaign_id(c_LEAD_ID NUMBER) IS

Line 1489: from as_leads_all

1485: WHERE LEAD_ID = c_LEAD_ID;
1486:
1487: CURSOR c_decision_date(c_lead_id NUMBER) IS
1488: select decision_date
1489: from as_leads_all
1490: where lead_id = c_lead_id;
1491:
1492: l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_lines';
1493: l_api_version_number CONSTANT NUMBER := 2.0;