DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on PO_VENDORS

Line 649: -- po_vendors.

645: ,X_msg_data OUT NOCOPY VARCHAR2) IS
646:
647: -- Cursor C1 is to Fetch Supplier wise Invoice details at Invoice Header Level for a project.
648: -- We pickup the payment details from ap_payment_schedules_all and vendor information from
649: -- po_vendors.
650:
651: /****
652: Modified below cursor for Bug# 7833675:
653: Removed the discount calculation from here.

Line 686: po_vendors vend

682: apinv.invoice_Type_Lookup_code invoice_type, /*Added for bug 8293625 */
683: apinv.cancelled_date Cancelled_Date /*Added for bug 8293625 */
684: from ap_invoices_all apinv,
685: ap_payment_schedules_all appay,
686: po_vendors vend
687: where exIsts (select 1 from
688: ap_invoice_dIstributions_all apd
689: where apd.project_id = P_project_Id
690: and apd.posted_flag ='Y'