DBA Data[Home] [Help]

APPS.AS_OPP_LINE_PVT dependencies on AS_STATUSES_VL

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