APPS.JA_CN_AP_VALIDATION_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 76: Xla_Transaction_Entities Ent,

72: CURSOR inv_id_cur
73: IS
74: SELECT Aia.Invoice_Id Invoice_Id
75: FROM Ap_Invoices_All Aia,
76: Xla_Transaction_Entities Ent,
77: Xla_Ae_Headers Aeh
78: WHERE Ent.Application_Id = 200
79: AND Aia.Invoice_Id = Ent.Source_Id_Int_1
80: AND Ent.Entity_Code = 'AP_INVOICES'

Line 89: Xla_Transaction_Entities Ent,

85: SELECT Aia.Invoice_Id Invoice_Id
86: FROM Ap_Invoices_All Aia,
87: Ap_Checks_All Ach,
88: Ap_Invoice_Payments_All Aip,
89: Xla_Transaction_Entities Ent,
90: Xla_Ae_Headers Aeh
91: WHERE Ent.Application_Id = 200
92: AND Aia.Invoice_Id = Aip.Invoice_Id
93: AND Ach.Check_Id = Aip.Check_Id

Line 212: Xla_Transaction_Entities Ent,

208: Gl_Periods Gp,
209: Xla_Ae_Lines Ael,
210: Xla_Ae_Headers Aeh,
211: Ap_Suppliers Sup,
212: Xla_Transaction_Entities Ent,
213: Ap_Invoices_All Aia
214: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id
215: AND Gir.Je_Header_Id = Jeh.Je_Header_Id
216: AND Gir.Je_Line_Num = Jel.Je_Line_Num

Line 340: Xla_Transaction_Entities Ent,

336: (ln_ae_header_id NUMBER)
337: IS
338: SELECT Aia.Invoice_Num Inv_Pay_Number
339: FROM Ap_Invoices_All Aia,
340: Xla_Transaction_Entities Ent,
341: Xla_Ae_Headers Aeh
342: WHERE Ent.Application_Id = 200
343: AND Aia.Invoice_Id = Ent.Source_Id_Int_1
344: AND Ent.Entity_Code = 'AP_INVOICES'

Line 351: Xla_Transaction_Entities Ent,

347: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
348: UNION
349: SELECT TO_CHAR(Aca.Check_Number) Inv_Pay_Number
350: FROM Ap_Checks_All Aca,
351: Xla_Transaction_Entities Ent,
352: Xla_Ae_Headers Aeh
353: WHERE Ent.Application_Id = 200
354: AND Aca.Check_Id = Ent.Source_Id_Int_1
355: AND Ent.Entity_Code = 'AP_PAYMENTS'