DBA Data[Home] [Help]

APPS.JA_CN_AP_VALIDATION_PKG dependencies on AP_CHECKS_ALL

Line 87: Ap_Checks_All Ach,

83: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
84: UNION
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

Line 350: FROM Ap_Checks_All Aca,

346: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
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