APPS.AS_SC_DENORM_TRG dependencies on AS_INTEREST_CODES_TL

Line 35: From as_interest_codes_tl

31: End;
32:
33: Begin
34: Select code into p_primary_interest_code
35: From as_interest_codes_tl
36: Where interest_code_id = p_primary_interest_code_id
37: And language = USERENV('LANG');
38: Exception When Others then
39: p_primary_interest_code := NULL;

Line 44: From as_interest_codes_tl

40: End;
41:
42: Begin
43: Select code into p_secondary_interest_code
44: From as_interest_codes_tl
45: Where interest_code_id = p_secondary_interest_code_id
46: AND language = USERENV('LANG');
47: Exception When Others then
48: p_secondary_interest_code := NULL;

Line 464: --l_primary_interest_code as_interest_codes_tl.code%TYPE;

460: From as_sales_credits
461: Where lead_line_id = p_lead_line_id;
462:
463: --l_interest_type as_interest_types_tl.interest_type%TYPE;
464: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
465: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
466: l_status as_leads_all.status%TYPE;
467: l_lead_total_amount as_leads_all.total_amount%TYPE;
468: l_decision_date as_leads_all.decision_date%TYPE;

Line 465: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;

461: Where lead_line_id = p_lead_line_id;
462:
463: --l_interest_type as_interest_types_tl.interest_type%TYPE;
464: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
465: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
466: l_status as_leads_all.status%TYPE;
467: l_lead_total_amount as_leads_all.total_amount%TYPE;
468: l_decision_date as_leads_all.decision_date%TYPE;
469: l_currency_code AS_LEADS_ALL.currency_code%TYPE;

Line 665: --l_primary_interest_code as_interest_codes_tl.code%TYPE;

661: l_last_name jtf_rs_resource_extns.source_last_name%TYPE;
662: l_employee_number jtf_rs_resource_extns.source_number%TYPE;
663: l_org_id as_leads_all.org_id%TYPE;
664: --l_interest_type as_interest_types_tl.interest_type%TYPE;
665: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
666: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
667: l_customer_id as_leads_all.customer_id%TYPE;
668: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
669: l_party_type as_party_customers_v.party_type%TYPE;

Line 666: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;

662: l_employee_number jtf_rs_resource_extns.source_number%TYPE;
663: l_org_id as_leads_all.org_id%TYPE;
664: --l_interest_type as_interest_types_tl.interest_type%TYPE;
665: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
666: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
667: l_customer_id as_leads_all.customer_id%TYPE;
668: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
669: l_party_type as_party_customers_v.party_type%TYPE;
670: l_address_id as_leads_all.address_id%TYPE;