APPS.PA_TIEBACK_ADJ_COSTS dependencies on PA_COST_DISTRIBUTION_LINES

Line 83: Pa_Cost_Distribution_Lines_All Cdl

79: From Dual
80: Where Exists
81: (Select 1
82: From Pa_Expenditure_Items_All Ei,
83: Pa_Cost_Distribution_Lines_All Cdl
84: Where Nvl(Ei.Adjusted_Expenditure_Item_Id,
85: Ei.Transferred_From_Exp_Item_Id) =
86: Cdl.Expenditure_Item_Id
87: And Nvl(Cdl.System_Reference4,'X') = To_Char(EiRec.Transaction_Id)

Line 216: From Pa_Cost_Distribution_Lines Cdl,

212: Select Cdl.RowId,
213: Cdl.Expenditure_Item_Id,
214: Cdl.Line_Num,
215: Inv.Status
216: From Pa_Cost_Distribution_Lines Cdl,
217: Ap_Invoices_Interface Inv,
218: Ap_Invoice_Lines_Interface Lines
219: Where Cdl.Transfer_Status_Code = 'I'
220: And Inv.Source = 'PA_COST_ADJUSTMENTS'

Line 279: Update PA_Cost_Distribution_Lines Cdl

275: Log_Message('Ei = ' || L_EiTab(i) ||
276: ' Line = ' || L_LineNumTab(i) ||
277: ' InvStatus = ' || l_InvStatusTab(i));
278:
279: Update PA_Cost_Distribution_Lines Cdl
280: Set (Cdl.System_Reference2,
281: Cdl.System_Reference3,
282: Cdl.gl_date,
283: Cdl.gl_period_name) =