APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on AP_INVOICE_LINES_ALL

Line 914: l_nit ap_invoice_lines_all.merchant_taxpayer_id%TYPE; -- ER 9435028

910:
911: l_supplier_num po_vendors.segment1%TYPE;
912: l_err_flag NUMBER;
913: l_invoice_line_number NUMBER; -- ER 9435028
914: l_nit ap_invoice_lines_all.merchant_taxpayer_id%TYPE; -- ER 9435028
915: l_nit_name ap_invoice_lines_all.merchant_name%TYPE; -- ER 9435028
916:
917:
918: BEGIN

Line 915: l_nit_name ap_invoice_lines_all.merchant_name%TYPE; -- ER 9435028

911: l_supplier_num po_vendors.segment1%TYPE;
912: l_err_flag NUMBER;
913: l_invoice_line_number NUMBER; -- ER 9435028
914: l_nit ap_invoice_lines_all.merchant_taxpayer_id%TYPE; -- ER 9435028
915: l_nit_name ap_invoice_lines_all.merchant_name%TYPE; -- ER 9435028
916:
917:
918: BEGIN
919:

Line 975: FROM ap_invoice_lines_all lines

971: FND_FILE.PUT_LINE(FND_FILE.log,'Deriving Merchant NIT information');
972: BEGIN
973: SELECT trim(merchant_taxpayer_id), trim(merchant_name)
974: INTO l_nit, l_nit_name
975: FROM ap_invoice_lines_all lines
976: WHERE lines.invoice_id = ap_trx.trx_hdr_id
977: AND lines.line_number = l_invoice_line_number;
978:
979: EXCEPTION