APPS.AS_SC_DENORM_TRG dependencies on AS_INTEREST_TYPES_TL

Line 25: From as_interest_types_tl

21: p_secondary_interest_code OUT NOCOPY Varchar2) IS
22: Begin
23: Begin
24: Select interest_type into p_interest_type
25: From as_interest_types_tl
26: Where interest_type_id = p_interest_type_id
27: And language = USERENV('LANG');
28: Exception
29: When Others then

Line 463: --l_interest_type as_interest_types_tl.interest_type%TYPE;

459: Select sales_credit_id, credit_amount, credit_percent
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;

Line 664: --l_interest_type as_interest_types_tl.interest_type%TYPE;

660: l_first_name jtf_rs_resource_extns.source_first_name%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;