DBA Data[Home] [Help]

APPS.AS_OPP_SALES_CREDIT_PVT dependencies on AS_STATUSES_VL

Line 516: From as_leads_all lead, as_statuses_vl status

512: Select lead.win_probability, status.win_loss_indicator,
513: status.forecast_rollup_flag
514: Into l_win_probability, l_win_loss_indicator,
515: l_forecast_rollup_flag
516: From as_leads_all lead, as_statuses_vl status
517: Where lead_id = l_sales_credit_rec.LEAD_ID
518: And lead.status = status.status_code(+);
519:
520: l_temp_bool := Apply_Forecast_Defaults(l_win_probability,

Line 1270: From as_leads_all lead, as_statuses_vl status

1266: Select lead.win_probability, status.win_loss_indicator,
1267: status.forecast_rollup_flag
1268: Into l_win_probability, l_win_loss_indicator,
1269: l_forecast_rollup_flag
1270: From as_leads_all lead, as_statuses_vl status
1271: Where lead_id = l_sales_credit_rec.LEAD_ID
1272: And lead.status = status.status_code(+);
1273:
1274: IF l_sales_credit_rec.CREDIT_TYPE_ID = l_forecast_credit_type_id THEN