APPS.AS_SC_DENORM_TRG dependencies on AS_STATUSES_VL

Line 283: From as_statuses_vl status

279:
280: Begin
281: Select meaning, win_loss_indicator, forecast_rollup_flag, opp_open_status_flag
282: Into l_status, l_win_loss_indicator, l_forecast_rollup_flag, l_opp_open_status_flag
283: From as_statuses_vl status
284: Where status.status_code = p_new_status;
285: Exception
286: When Others then
287: l_status := Null;

Line 493: From as_leads_all lead, as_statuses_vl status

489: If p_trigger_mode = 'ON-UPDATE' then
490: Begin
491: Select lead.total_amount , trunc(lead.decision_date) decision_date, lead.currency_code, lead.win_probability, status.win_loss_indicator
492: Into l_lead_total_amount, l_decision_date, l_currency_code, l_win_probability, l_status
493: From as_leads_all lead, as_statuses_vl status
494: Where lead_id = p_new_lead_id
495: And lead.status = status.status_code(+);
496:
497: If p_new_frcst_date IS NULL THEN

Line 971: From as_statuses_vl status,

967:
968: Begin
969: Select meaning, win_loss_indicator, forecast_rollup_flag, opp_open_status_flag
970: Into l_status, l_win_loss_indicator, l_forecast_rollup_flag, l_opp_open_status_flag
971: From as_statuses_vl status,
972: as_leads_all lead
973: Where lead.status = status.status_code
974: --And status.language = userenv('LANG')
975: And lead.lead_id = p_new_lead_id;