APPS.JA_CN_SR_EXPORT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 65

SELECT DISTINCT
DECODE(ai.INVOICE_TYPE_LOOKUP_CODE, 'PAYMENT REQUEST', NULL,
                   PV.SEGMENT1) AS Supplier_Number
,VENDOR_NAME AS Supplier_Name, VENDOR_NAME AS Supplier_Short_Name
FROM PO_VENDORS pv, AP_INVOICES_ALL ai
WHERE pv.VENDOR_ID = ai.VENDOR_ID
AND pv.EMPLOYEE_ID IS NULL --'Standard Supplier' only
AND ai.LEGAL_ENTITY_ID = pn_legal_entity_id  --LEGAL_ENTITY_ID
AND to_char(ai.GL_DATE,'YYYY') = pv_accounting_year  --Accounting Year
AND AP_INVOICES_PKG.GET_APPROVAL_STATUS( ai.INVOICE_ID,
ai.INVOICE_AMOUNT, ai.PAYMENT_STATUS_FLAG,ai.INVOICE_TYPE_LOOKUP_CODE) IN
('APPROVED','AVAILABLE','CANCELLED','FULL','PERMANENT','UNPAID','SELECTED FOR PAYMENT')
ORDER BY Supplier_Number;