APPS.JA_CN_SR_EXPORT_PKG dependencies on AP_INVOICES_PKG

Line 74: AND AP_INVOICES_PKG.GET_APPROVAL_STATUS( ai.INVOICE_ID,

70: WHERE pv.VENDOR_ID = ai.VENDOR_ID
71: AND pv.EMPLOYEE_ID IS NULL --'Standard Supplier' only
72: AND ai.LEGAL_ENTITY_ID = pn_legal_entity_id --LEGAL_ENTITY_ID
73: AND to_char(ai.GL_DATE,'YYYY') = pv_accounting_year --Accounting Year
74: AND AP_INVOICES_PKG.GET_APPROVAL_STATUS( ai.INVOICE_ID,
75: ai.INVOICE_AMOUNT, ai.PAYMENT_STATUS_FLAG,ai.INVOICE_TYPE_LOOKUP_CODE) IN
76: ('APPROVED','AVAILABLE','CANCELLED','FULL','PERMANENT','UNPAID','SELECTED FOR PAYMENT')
77: ORDER BY Supplier_Number;
78: