APPS.LNS_IMPORT_LOAN_PUB dependencies on LNS_LOAN_TYPES

Line 615: from lns_loan_types loan_type,

611:
612: BEGIN
613: SELECT loan_type.loan_class_code
614: INTO l_loan_class
615: from lns_loan_types loan_type,
616: lns_loan_products_all loan_product
617: where loan_product.loan_product_id = P_Loan_Details_Rec.product_id AND
618: loan_type.loan_type_id = loan_product.loan_type_id ;
619: EXCEPTION

Line 632: from lns_loan_types loan_type,

628: logmessage(fnd_log.level_statement, 'Validating product...');
629: BEGIN
630: SELECT 'Y'
631: INTO l_dummy
632: from lns_loan_types loan_type,
633: lns_loan_products_all loan_product
634: where loan_product.loan_product_id = P_Loan_Details_Rec.product_id AND
635: loan_type.loan_type_id = loan_product.loan_type_id AND
636: loan_type.loan_class_code = 'ERS';