APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on AP_CHECKS_ALL

Line 1538: ' FROM Ap_Checks_All' || ' WHERE Check_Id =' ||

1534:
1535: IF lv_attribute_column4bill_num IS NOT NULL --Defined in DFF assignment form
1536: THEN
1537: lv_cursor_sql := 'SELECT ' || lv_attribute_column4bill_num ||
1538: ' FROM Ap_Checks_All' || ' WHERE Check_Id =' ||
1539: pn_check_id || ' AND Attribute_Category=''' ||
1540: lv_context_code || ''''; --Updated for fixing bug# 9793920
1541:
1542: OPEN v_bill_num_row for lv_cursor_sql;

Line 1697: Ap_Checks_All Ach,

1693: /*SELECT SUM(NVL(Ael.Entered_Dr,
1694: 0) + -1 * NVL(Ael.Entered_Cr,
1695: 0)) Paid_Amount
1696: FROM Ap_Invoices_All Aia,
1697: Ap_Checks_All Ach,
1698: Ap_Invoice_Payments_All Aip,
1699: Xla_Transaction_Entities Ent,
1700: Xla_Ae_Headers Aeh,
1701: Xla_Ae_Lines Ael,

Line 1739: FROM Ap_Checks_All Ach,

1735: WHERE Aia.Invoice_Id = Aip.Invoice_Id
1736: AND Aia.Invoice_Id = pn_invoice_id -- parameter: pn_invoice_id
1737: AND EXISTS
1738: (SELECT Ach.Check_Id
1739: FROM Ap_Checks_All Ach,
1740: Xla_Transaction_Entities Ent,
1741: Xla_Ae_Headers Aeh,
1742: Xla_Ae_Lines Ael,
1743: Gl_Je_Headers Jeh,

Line 2718: Ap_Checks_All Ach,

2714: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2715: UNION
2716: SELECT Aia.Invoice_Id Invoice_Id
2717: FROM Ap_Invoices_All Aia,
2718: Ap_Checks_All Ach,
2719: Ap_Invoice_Payments_All Aip,
2720: Xla_Transaction_Entities Ent,
2721: Xla_Ae_Headers Aeh
2722: WHERE Ent.Application_Id = 200

Line 2888: Ap_Checks_All Ach,

2884: TO_CHAR(Ach.CHECK_DATE, 'YYYYMMDD') Payment_Date,
2885: '' Clear_Flag,
2886: '' Remittance_Bill_Number
2887: FROM Ap_Invoices_All Aia,
2888: Ap_Checks_All Ach,
2889: Ap_Invoice_Payments_All Aip,
2890: Xla_Transaction_Entities Ent,
2891: Xla_Ae_Headers Aeh,
2892: Xla_Ae_Lines Ael,