DBA Data[Home] [Help]

APPS.PA_BILLING_CYCLES_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 397: FROM PA_Draft_Invoices_All

393: /* Added retention_invoice_flag condition for Bug2385594 */
394:
395: SELECT MAX(NVL(Bill_through_date, Creation_date))
396: INTO Last_Bill_thru_date
397: FROM PA_Draft_Invoices_All
398: WHERE Project_id = X_project_id
399: AND nvl(retention_invoice_flag, 'N') = 'N'
400: AND Draft_Invoice_Num_Credited IS NULL
401: AND Released_By_Person_ID IS NOT NULL