APPS.AS_SC_DENORM_TRG dependencies on AR_LOOKUPS

Line 158: l_customer_category ar_lookups.meaning%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;
158: l_customer_category ar_lookups.meaning%TYPE;
159: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;
160: l_total_amount NUMBER;
161: l_sc_amount NUMBER;
162: l_won_amount NUMBER;

Line 197: From ar_lookups arlkp

193:
194: Begin
195: Select meaning
196: Into l_customer_category
197: From ar_lookups arlkp
198: Where arlkp.lookup_type = 'CUSTOMER_CATEGORY'
199: And arlkp.lookup_code = l_customer_category_code;
200: Exception
201: When others then

Line 700: l_customer_category ar_lookups.meaning%TYPE;

696: l_secondary_interest_code_id as_lead_lines_all.SECONDARY_INTEREST_CODE_ID%TYPE;
697: l_product_category_id as_lead_lines_all.PRODUCT_CATEGORY_ID%TYPE;
698: l_product_cat_set_id as_lead_lines_all.PRODUCT_CAT_SET_ID%TYPE;
699: l_currency_code as_leads_all.currency_code%TYPE;
700: l_customer_category ar_lookups.meaning%TYPE;
701: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;
702: l_leadline_total_amount as_lead_lines_all.total_amount%TYPE;
703: l_lead_total_amount as_leads_all.total_amount%TYPE;
704: l_total_amount NUMBER;

Line 885: From ar_lookups arlkp

881:
882: Begin
883: Select meaning
884: Into l_customer_category
885: From ar_lookups arlkp
886: Where arlkp.lookup_type = 'CUSTOMER_CATEGORY'
887: And arlkp.lookup_code = l_customer_category_code;
888: Exception When others then
889: l_customer_category := Null;