APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on AP_CHECKS_ALL

Line 32: FROM ap_invoice_payments_all a, ap_checks_all b

28: b.currency_code,
29: b.exchange_rate,
30: b.exchange_date,
31: b.exchange_rate_type
32: FROM ap_invoice_payments_all a, ap_checks_all b
33: WHERE a.check_id = b.check_id
34: AND a.invoice_payment_id = cp_invoice_payment_id;
35:
36: cursor c_get_curr_dtls(cp_invoice_id NUMBER) IS

Line 162: ap_checks_all b,

158: aida.parent_reversal_id,
159: aida.rcv_transaction_id,
160: aida.po_distribution_id
161: FROM ap_invoice_payments_all a,
162: ap_checks_all b,
163: ap_invoice_distributions_all aida
164: WHERE a.invoice_id = cp_invoice_id
165: AND a.check_id = b.check_id
166: AND a.invoice_id = aida.invoice_id

Line 206: ap_checks_all apc,

202: apinvp.amount,
203: apinvp.org_id,
204: apinvp.accounting_date
205: FROM ap_invoice_payments_all apinvp,
206: ap_checks_all apc,
207: ap_invoice_distributions_all ainvd,
208: jai_rgm_trx_refs jrtr /* second table is used for join just to take IL records */
209: WHERE apinvp.org_id = p_org_id
210: AND apinvp.check_id = apc.check_id