DBA Data[Home] [Help]

APPS.PA_TIEBACK_ADJ_COSTS dependencies on AP_INVOICE_DISTRIBUTIONS

Line 293: From Ap_Invoice_Distributions Dist

289: Dist.Accounting_Date,Cdl.Gl_Date),
290: Decode(l_InvStatusTab(i),'PROCESSED',
291: Pa_Utils2.Get_Gl_Period_Name(Dist.Accounting_Date,Dist.Org_Id),
292: Cdl.Gl_Period_Name)
293: From Ap_Invoice_Distributions Dist
294: Where Dist.Reference_2 = To_Char(Cdl.Expenditure_Item_Id) || '-' ||
295: to_char(Cdl.Line_Num)
296: And Pa_Addition_Flag = 'T'),
297: Cdl.Transfer_Status_Code = Decode(l_InvStatusTab(i), 'PROCESSED','A',

Line 306: /* Need new index in ap_invoice_distributions(reference_2) */

302: Cdl.Program_Id = G_PROGRAM_ID,
303: Cdl.Program_Update_Date = sysdate
304: Where Cdl.RowId = l_RowIdTab(i);
305:
306: /* Need new index in ap_invoice_distributions(reference_2) */
307:
308: End Loop;
309:
310: For i in l_RowIdTab.first..l_RowIdTab.last Loop