DBA Data[Home] [Help]

APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AP_INVOICES_PKG

Line 1222: , AP_INVOICES_PKG.GET_APPROVAL_STATUS( INV.INVOICE_ID, INV.INVOICE_AMOUNT, INV.PAYMENT_STATUS_FLAG, INV.INVOICE_TYPE_LOOKUP_CODE) --"status_code"

1218: , null --"settlement_type_id"
1219: , inv.invoice_num --"settlement_number"
1220: , inv.invoice_date --"settlement_date"
1221: , inv.invoice_amount --"settlement_amount"
1222: , AP_INVOICES_PKG.GET_APPROVAL_STATUS( INV.INVOICE_ID, INV.INVOICE_AMOUNT, INV.PAYMENT_STATUS_FLAG, INV.INVOICE_TYPE_LOOKUP_CODE) --"status_code"
1223: , 'AP_DEBIT' --"payment_method"
1224: , NULL
1225: , inv.invoice_amount
1226: FROM ap_invoices_all inv