DBA Data[Home] [Help]

APPS.AS_SC_DENORM_TRG dependencies on AS_SALES_STAGES_ALL_TL

Line 272: From as_sales_stages_all_tl sales

268:
269: Begin
270: Select name
271: Into l_sales_stage
272: From as_sales_stages_all_tl sales
273: Where sales.sales_stage_id = p_new_sales_stage_id
274: And language = USERENV('LANG');
275: Exception
276: When Others then

Line 960: From as_sales_stages_all_tl sales, as_leads_all lead

956:
957: Begin
958: Select name
959: Into l_sales_stage
960: From as_sales_stages_all_tl sales, as_leads_all lead
961: Where sales.sales_stage_id = lead.sales_stage_id
962: And lead.lead_id = p_new_lead_id
963: And sales.language = userenv('LANG');
964: Exception When Others then