APPS.PA_INVOICE_TRANSFER dependencies on PA_DRAFT_INVOICE_ITEMS

Line 19: from pa_draft_invoice_items dii

15: -- Check any invoice line has invalid tax id
16:
17: Select 'x'
18: Into pl_dummy
19: from pa_draft_invoice_items dii
20: where draft_invoice_num = P_Draft_Invoice_Num
21: and project_id = P_Project_ID
22: -- and output_vat_tax_id is not null
23: and output_tax_classification_code is not null

Line 86: From PA_Draft_Invoice_Items Item

82: -- Determine the invoice amount
83:
84: Select Sum(Item.Amount), Sum(Item.Inv_Amount)
85: Into Project_Amount, Invoice_Amount
86: From PA_Draft_Invoice_Items Item
87: Where Item.Project_ID = P_Project_ID
88: And Item.Draft_Invoice_Num = P_Draft_Invoice_Num
89: And Item.Invoice_Line_Type <> 'NET ZERO ADJUSTMENT';
90:

Line 231: From PA_Draft_Invoice_Items

227: /* If AR_Tax_Flag = 'Y'
228: Then
229: Select 'x'
230: Into l_dummy
231: From PA_Draft_Invoice_Items
232: Where Project_id = P_Project_Id
233: And Draft_Invoice_num = P_Draft_Inv_Num
234: AND output_tax_classification_code IS NULL
235: -- And Output_vat_tax_id is Null