APPS.JA_CN_AP_VALIDATION_PKG dependencies on AP_INVOICES_ALL

Line 67: AP_INVOICES_ALL aia

63: IS
64: SELECT DISTINCT part.party_name Customer_Name
65: FROM HZ_CUST_ACCOUNTS cust,
66: HZ_PARTIES part,
67: AP_INVOICES_ALL aia
68: WHERE cust.cust_account_id = aia.party_id
69: AND cust.party_id = part.party_id
70: AND aia.Invoice_Id = ln_invoice_id; --variable: ln_invoice_id
71:

Line 75: FROM Ap_Invoices_All Aia,

71:
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

Line 86: FROM Ap_Invoices_All Aia,

82: AND Aeh.Ae_Header_Id = pn_ae_header_id --parameter: pn_ae_header_id
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

Line 213: Ap_Invoices_All Aia

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
217: AND Jcc.Code_Combination_Id = Jel.Code_Combination_Id

Line 339: FROM Ap_Invoices_All Aia,

335: CURSOR inv_pay_num_cur
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