APPS.JL_AR_AUTOINV_PKG dependencies on JL_AR_AR_DOC_LETTER

Line 142: FROM jl_ar_ar_doc_letter;

138: -- Get VAT tax category from document letter table
139: BEGIN
140: SELECT distinct tax_category_id
141: INTO l_tax_category_id
142: FROM jl_ar_ar_doc_letter;
143:
144: EXCEPTION WHEN NO_DATA_FOUND THEN
145: arp_file.write_log('Document letter not set up',0);
146: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

Line 246: FROM jl_ar_ar_doc_letter

242: l_cust_attribute_name IS NOT NULL AND l_cust_attribute_value IS NOT NULL THEN
243: BEGIN
244: SELECT document_letter
245: INTO l_document_letter
246: FROM jl_ar_ar_doc_letter
247: WHERE tax_category_id = l_tax_category_id
248: AND org_tax_attribute_name = l_org_attribute_name
249: AND org_tax_attribute_value = l_org_attribute_value
250: AND con_tax_attribute_name = l_cust_attribute_name