1088: END IF;
1089:
1090: SELECT displayed_field
1091: INTO l_nls_int_inv_desc
1092: FROM ap_lookup_codes
1093: WHERE lookup_type = 'NLS TRANSLATION'
1094: AND lookup_code = 'INTEREST OVERDUE INVOICE';
1095:
1096:
1665: SYSDATE,
1666: l_last_updated_by,
1667: i.org_id
1668: FROM ap_invoices_all I,
1669: ap_lookup_codes LC
1670: WHERE I.batch_id= l_int_batch_id
1671: AND LC.lookup_type = 'NLS TRANSLATION' /* bug 9868737 */
1672: AND LC.lookup_code = 'INTEREST ON PAYMENTBATCH' /* bug 9868737 */
1673: GROUP BY l_int_batch_id, l_checkrun_name,