DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_LOOKUP_CODES

Line 895: FROM ap_lookup_codes

891: END IF;
892:
893: SELECT displayed_field
894: INTO l_nls_int_inv_desc
895: FROM ap_lookup_codes
896: WHERE lookup_type = 'NLS TRANSLATION'
897: AND lookup_code = 'INTEREST OVERDUE INVOICE';
898:
899:

Line 1495: ap_lookup_codes LC

1491: SYSDATE,
1492: l_last_updated_by,
1493: i.org_id
1494: FROM ap_invoices_all I,
1495: ap_lookup_codes LC
1496: WHERE I.batch_id= l_int_batch_id
1497: AND LC.lookup_code = 'NLS TRANLSATION'
1498: AND LC.lookup_type = 'INTEREST ON PAYMENTBATCH'
1499: GROUP BY l_int_batch_id, l_checkrun_name,