APPS.PA_BILLING_CYCLES_PKG dependencies on PA_DRAFT_INVOICES

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

Line 435: FROM PA_Draft_Invoices DI

431: /** Get invoice num **/
432:
433: SELECT MAX(DI.Draft_Invoice_Num)
434: INTO Invoice_Num
435: FROM PA_Draft_Invoices DI
436: WHERE DI.Project_ID = X_Project_id
437: AND DI.Draft_Invoice_Num_Credited IS NULL
438: AND DI.Released_By_Person_ID IS NOT NULL
439: AND NVL(DI.Canceled_Flag,'N') = 'N'

Line 442: FROM PA_Draft_Invoices PDI

438: AND DI.Released_By_Person_ID IS NOT NULL
439: AND NVL(DI.Canceled_Flag,'N') = 'N'
440: AND NVL(DI.Bill_through_date, DI.Creation_date) = (
441: SELECT MAX(NVL(PDI.Bill_through_date, PDI.Creation_date))
442: FROM PA_Draft_Invoices PDI
443: WHERE PDI.Project_ID = DI.Project_ID
444: AND PDI.Draft_Invoice_Num_Credited IS NULL
445: AND PDI.Released_By_Person_ID IS NOT NULL
446: AND NVL(PDI.Canceled_Flag,'N') = 'N'