APPS.JE_IL_TAX_PKG dependencies on AP_INVOICE_PAYMENTS

Line 99: ap_invoice_payments aip ,

95: xlah.ledger_id,
96: SUM(xdln.unrounded_accounted_dr) gross_amount,
97: MIN(aip.invoice_id) invoice_id
98: FROM ap_invoice_distributions aid ,
99: ap_invoice_payments aip ,
100: ap_payment_hist_dists payh ,
101: xla_distribution_links xdln ,
102: xla_ae_headers xlah
103: WHERE aip.invoice_id = pn_invoice_id

Line 128: ap_invoice_payments aip ,

124: xlah.ledger_id,
125: SUM(xdln.unrounded_accounted_dr) gross_amount,
126: MIN(aip.invoice_id) invoice_id
127: FROM ap_invoice_distributions aid ,
128: ap_invoice_payments aip ,
129: ap_payment_hist_dists payh ,
130: xla_distribution_links xdln ,
131: xla_ae_headers xlah
132: WHERE aip.invoice_id = pn_invoice_id

Line 160: ap_invoice_payments_all aip

156: FROM ap_invoice_distributions_all aid ,
157: ap_payment_hist_dists payh ,
158: xla_distribution_links xdln ,
159: xla_ae_headers xlah ,
160: ap_invoice_payments_all aip
161: WHERE aid.invoice_id = cn_invoice_id
162: AND aip.invoice_payment_id = payh.invoice_payment_id
163: AND aip.check_id = pn_check_id
164: AND aid.line_type_lookup_code ='AWT'

Line 180: FROM ap_invoice_payments aip,

176: xlah.ledger_id;
177:
178: CURSOR c_get_invwht_check (cn_invoice_id NUMBER) IS
179: SELECT ai.invoice_id invoice_id
180: FROM ap_invoice_payments aip,
181: ap_invoice_distributions aid,
182: ap_invoices ai
183: WHERE ai.invoice_id = cn_invoice_id
184: AND ai.invoice_id = aip.invoice_id

Line 270: FROM ap_invoice_payments aip

266: fnd_file.put_line(fnd_file.log,'Return from Cursor c_get_invevent_awt:Invoice ID:'||ln_invoice_id||'Amount:'||ln_gross_amount);
267: END IF;
268: BEGIN
269: SELECT SIGN(NVL(aip.payment_base_amount,aip.amount)) INTO ln_sign
270: FROM ap_invoice_payments aip
271: WHERE aip.invoice_id = ln_invoice_id
272: AND aip.accounting_event_id = ln_event_id;
273: EXCEPTION
274: WHEN others THEN