APPS.AS_SC_DENORM_TRG dependencies on AS_SALES_STAGES

Line 153: l_sales_stage as_sales_stages.name%TYPE;

149:
150: l_customer_id as_leads_all.customer_id%TYPE;
151: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
152: l_party_type as_party_customers_v.party_type%TYPE;
153: l_sales_stage as_sales_stages.name%TYPE;
154: l_status as_statuses_tl.meaning%TYPE;
155: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
156: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
157: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;

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 684: l_sales_stage as_sales_stages.name%TYPE;

680: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
681: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
682: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
683: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
684: l_sales_stage as_sales_stages.name%TYPE;
685: l_win_probability as_leads_all.win_probability%TYPE;
686: l_status_code as_leads_all.status%TYPE;
687: l_sales_methodology_id as_leads_all.sales_methodology_id%TYPE;
688: l_status as_statuses_tl.meaning%TYPE;

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