APPS.PA_INVOICE_TRANSFER dependencies on PA_DRAFT_INVOICES

Line 77: From PA_Draft_Invoices I, PA_Projects P

73: -- Determine the Invoice Date
74:
75: Select I.Invoice_Date, I.Inv_Currency_Code, P.Project_Currency_Code
76: Into Invoice_date, Inv_Currency_Code, Project_Currency_Code
77: From PA_Draft_Invoices I, PA_Projects P
78: WHERE P.Project_id = P_Project_ID
79: AND I.Project_id = P_Project_ID
80: AND Draft_Invoice_Num = P_Draft_Invoice_Num;
81:

Line 100: From PA_Draft_Invoices Orig,

96: Invoice_Class := 'WRITE_OFF';
97: ELSE
98: Select decode(Orig.Canceled_Flag,'Y','CANCEL','CREDIT_MEMO')
99: Into Invoice_Class
100: From PA_Draft_Invoices Orig,
101: PA_Draft_Invoices Curr
102: Where Curr.Project_ID = P_Project_ID
103: AND Curr.Draft_Invoice_Num = P_Draft_Invoice_Num
104: AND Orig.Project_ID = Curr.Project_ID

Line 101: PA_Draft_Invoices Curr

97: ELSE
98: Select decode(Orig.Canceled_Flag,'Y','CANCEL','CREDIT_MEMO')
99: Into Invoice_Class
100: From PA_Draft_Invoices Orig,
101: PA_Draft_Invoices Curr
102: Where Curr.Project_ID = P_Project_ID
103: AND Curr.Draft_Invoice_Num = P_Draft_Invoice_Num
104: AND Orig.Project_ID = Curr.Project_ID
105: AND Orig.Draft_Invoice_Num = Curr.Draft_Invoice_Num_Credited;