[Home] [Help]
1982: fv_fund_parameters ffp,
1983: fv_treasury_symbols fts,
1984: ap_invoices_all ai,
1985: ap_invoice_distributions_all aid,
1986: ap_invoice_payments_all aip,
1987: ap_payment_hist_dists aphd,
1988: gl_import_references glir,
1989: xla_ae_headers xah,
1990: xla_ae_lines xal,
2096: fv_fund_parameters ffp,
2097: fv_treasury_symbols fts,
2098: ap_invoices_all ai,
2099: ap_invoice_distributions_all aid,
2100: ap_invoice_payments_all aip,
2101: gl_import_references glir,
2102: xla_ae_headers xah,
2103: xla_ae_lines xal,
2104: xla_events xet,
2188: fv_fund_parameters ffp,
2189: fv_treasury_symbols fts,
2190: ap_invoices_all ai,
2191: ap_invoice_distributions_all aid,
2192: ap_invoice_payments_all aip,
2193: gl_import_references glir,
2194: xla_ae_headers xah,
2195: xla_ae_lines xal,
2196: xla_events xet,
2301: fv_report_definitions frd,
2302: fv_fund_parameters ffp,
2303: fv_treasury_symbols fts,
2304: ap_invoice_distributions_all aid,
2305: ap_invoice_payments_all aip,
2306: ap_payment_hist_dists aphd,
2307: gl_import_references glir,
2308: xla_ae_headers xah,
2309: xla_ae_lines xal,
3359: ELSE
3360: BEGIN
3361: select 'Y'
3362: into l_exists
3363: from ap_invoice_payments_all
3364: Where invoice_payment_id = to_number(l_REFERENCE_9) ;
3365: EXCEPTION
3366: when no_data_found then
3367: x_name := 'Invalid Invoice Payment Id - '|| l_reference_9 ;
4038: ELSIF (l_je_source = 'Payables' AND l_je_category <> 'Treasury Confirmation') THEN -- source2
4039: BEGIN
4040: SELECT Distinct org_id
4041: INTO l_org_id
4042: FROM ap_invoice_payments_all
4043: WHERE invoice_id = to_number(l_reference_2) ;
4044: EXCEPTION
4045: WHEN OTHERS THEN
4046: error_code := 2;
4533: END;
4534: BEGIN
4535: SELECT 'Y'
4536: INTO l_voided_reclassified_payment
4537: FROM AP_INVOICE_PAYMENTS_ALL APP
4538: WHERE APP.CHECK_ID = TO_NUMBER(L_REFERENCE_3)
4539: AND APP.invoice_payment_id = TO_NUMBER(L_REFERENCE_9)
4540: AND APP.reversal_inv_pmt_id IS NOT NULL
4541: AND APP.reversal_flag ='Y';
5601: WHERE po_distribution_id = apid.po_distribution_id)))
5602: obligation_number
5603: FROM
5604: ap_checks_all apc,
5605: ap_invoice_payments_all apip,
5606: ap_invoices_all api,
5607: ap_invoice_distributions_all apid
5608: WHERE apip.set_of_books_id = l_set_of_books_id
5609: AND apip.set_of_books_id = api.set_of_books_id