APPS.JA_CN_CFS_REPORT_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 115: FROM Xla_Distribution_Links

111: DECODE(NVL(UNROUNDED_ACCOUNTED_DR, '-1'),
112: '-1',
113: UNROUNDED_ACCOUNTED_CR,
114: -1 * UNROUNDED_ACCOUNTED_DR)
115: FROM Xla_Distribution_Links
116: WHERE Ae_Header_Id = p_Ae_Header_Id
117: AND Ae_Line_Num = p_Ae_Line_Num;
118: --Fix bug#6697073 end----------------------------------------
119:

Line 189: FROM Xla_Distribution_Links

185: x_Func_Amount:= l_func_amount_array;
186:
187: /* SELECT DISTINCT Applied_To_Source_Id_Num_1
188: INTO l_Invoice_Id
189: FROM Xla_Distribution_Links
190: WHERE Ae_Header_Id = p_Ae_Header_Id
191: AND Ae_Line_Num = p_Ae_Line_Num;
192: -- get invoice number for current invoice
193: IF l_invoice_id is not null

Line 287: FROM Xla_Distribution_Links

283: DECODE(NVL(UNROUNDED_ACCOUNTED_DR, '-1'),
284: '-1',
285: UNROUNDED_ACCOUNTED_CR,
286: -1 * UNROUNDED_ACCOUNTED_DR)
287: FROM Xla_Distribution_Links
288: WHERE Ae_Header_Id = p_Ae_Header_Id
289: AND Ae_Line_Num = p_Ae_Line_Num;
290: --Fix bug#6697073 end-------------------------------------------------------
291:

Line 362: FROM Xla_Distribution_Links

358: /*
359: --Get transaction ID
360: SELECT DISTINCT Applied_To_Source_Id_Num_1+0
361: INTO l_Customer_Trx_Id
362: FROM Xla_Distribution_Links
363: WHERE Ae_Header_Id = p_Ae_Header_Id
364: AND Ae_Line_Num = p_Ae_Line_Num;
365: --get invoice number
366: IF L_CUSTOMER_TRX_ID IS NOT NULL