DBA Data[Home] [Help]

APPS.JL_AR_AUTOINV_PKG dependencies on JL_AR_AR_DOC_LETTER

Line 167: FROM jl_ar_ar_doc_letter;

163: -- Get VAT tax category from document letter table
164: BEGIN
165: SELECT distinct tax_category_id
166: INTO l_tax_category_id
167: FROM jl_ar_ar_doc_letter;
168:
169: EXCEPTION WHEN NO_DATA_FOUND THEN
170: arp_file.write_log('Document letter not set up',0);
171: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',

Line 271: FROM jl_ar_ar_doc_letter

267: l_cust_attribute_name IS NOT NULL AND l_cust_attribute_value IS NOT NULL THEN
268: BEGIN
269: SELECT document_letter
270: INTO l_document_letter
271: FROM jl_ar_ar_doc_letter
272: WHERE tax_category_id = l_tax_category_id
273: AND org_tax_attribute_name = l_org_attribute_name
274: AND org_tax_attribute_value = l_org_attribute_value
275: AND con_tax_attribute_name = l_cust_attribute_name