DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on FND_CURRENCY

Line 457: ,to_char(NVL(linked_inv.invoice_amount,0),fnd_currency.GET_FORMAT_MASK(linked_inv.proj_currency_code, 20)) invoice_amount

453: CURSOR c_linked_invoice (l_project_id NUMBER
454: ,l_draft_inv_num NUMBER)
455: IS
456: SELECT ap_inv.invoice_num invoice_number
457: ,to_char(NVL(linked_inv.invoice_amount,0),fnd_currency.GET_FORMAT_MASK(linked_inv.proj_currency_code, 20)) invoice_amount
458: ,ap_inv.invoice_date invoice_date
459: ,po_vend.vendor_name supplier_name
460: FROM (
461: SELECT ap_invoice_id Invoice_id