DBA Data[Home] [Help]

APPS.FV_SF224_TRANSACTIONS dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1960: ap_invoice_payments_all aip,

1956: fv_fund_parameters ffp,
1957: fv_treasury_symbols fts,
1958: ap_invoices_all ai,
1959: ap_invoice_distributions_all aid,
1960: ap_invoice_payments_all aip,
1961: ap_payment_hist_dists aphd,
1962: gl_import_references glir,
1963: xla_ae_headers xah,
1964: xla_ae_lines xal,

Line 2073: ap_invoice_payments_all aip,

2069: fv_fund_parameters ffp,
2070: fv_treasury_symbols fts,
2071: ap_invoices_all ai,
2072: ap_invoice_distributions_all aid,
2073: ap_invoice_payments_all aip,
2074: gl_import_references glir,
2075: xla_ae_headers xah,
2076: xla_ae_lines xal,
2077: xla_events xet,

Line 2182: ap_invoice_payments_all aip,

2178: fv_report_definitions frd,
2179: fv_fund_parameters ffp,
2180: fv_treasury_symbols fts,
2181: ap_invoice_distributions_all aid,
2182: ap_invoice_payments_all aip,
2183: ap_payment_hist_dists aphd,
2184: gl_import_references glir,
2185: xla_ae_headers xah,
2186: xla_ae_lines xal,

Line 3228: from ap_invoice_payments_all

3224: ELSE
3225: BEGIN
3226: select 'Y'
3227: into l_exists
3228: from ap_invoice_payments_all
3229: Where invoice_payment_id = to_number(l_REFERENCE_9) ;
3230: EXCEPTION
3231: when no_data_found then
3232: x_name := 'Invalid Invoice Payment Id - '|| l_reference_9 ;

Line 3907: FROM ap_invoice_payments_all

3903: ELSIF (l_je_source = 'Payables' AND l_je_category <> 'Treasury Confirmation') THEN -- source2
3904: BEGIN
3905: SELECT Distinct org_id
3906: INTO l_org_id
3907: FROM ap_invoice_payments_all
3908: WHERE invoice_id = to_number(l_reference_2) ;
3909: EXCEPTION
3910: WHEN OTHERS THEN
3911: error_code := 2;

Line 4399: FROM AP_INVOICE_PAYMENTS_ALL APP

4395: END;
4396: BEGIN
4397: SELECT 'Y'
4398: INTO l_voided_reclassified_payment
4399: FROM AP_INVOICE_PAYMENTS_ALL APP
4400: WHERE APP.CHECK_ID = TO_NUMBER(L_REFERENCE_3)
4401: AND APP.invoice_payment_id = TO_NUMBER(L_REFERENCE_9)
4402: AND APP.reversal_inv_pmt_id IS NOT NULL
4403: AND APP.reversal_flag ='Y';

Line 5461: ap_invoice_payments_all apip,

5457: WHERE po_distribution_id = apid.po_distribution_id)))
5458: obligation_number
5459: FROM
5460: ap_checks_all apc,
5461: ap_invoice_payments_all apip,
5462: ap_invoices_all api,
5463: ap_invoice_distributions_all apid
5464: WHERE apip.set_of_books_id = l_set_of_books_id
5465: AND apip.set_of_books_id = api.set_of_books_id