APPS.FV_DUE_DATE_CALCULATION dependencies on AP_INVOICES_PKG

Line 31: AND ap_invoices_pkg.get_approval_status(

27: --ap_invoice_distributions aid,
28: ap_payment_schedules aps
29: WHERE api.cancelled_amount IS NULL
30: AND api.invoice_type_lookup_code <> 'INTEREST'
31: AND ap_invoices_pkg.get_approval_status(
32: api.invoice_id,
33: api.invoice_amount,
34: api.payment_status_flag,
35: api.invoice_type_lookup_code)='APPROVED'