eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 2305: FROM ap_invoice_payments AIP, ap_payment_history_all APH

2301: -- Payment Adjustment Events.
2302: CURSOR l_invoice_payments_cur IS --bug 7042296
2303: SELECT distinct(AIP.check_id),
2304: APH.accounting_event_id
2305: FROM ap_invoice_payments AIP, ap_payment_history_all APH
2306: WHERE AIP.invoice_id = p_invoice_id
2307: AND AIP.accounting_event_id IS NOT NULL
2308: and AIP.check_id = APH.check_id
2309: and APH.accounting_event_id is not null

Line 3489: INSERT INTO ap_payment_history_all

3485: END IF;
3486:
3487: BEGIN
3488:
3489: INSERT INTO ap_payment_history_all
3490: ( payment_history_id,
3491: check_id,
3492: accounting_date,
3493: transaction_type,

Line 3573: FROM ap_payment_history_all aph,

3569: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3570:
3571: SELECT COUNT(*)
3572: INTO l_count
3573: FROM ap_payment_history_all aph,
3574: ap_checks_all ac
3575: WHERE aph.check_id = ac.check_id
3576: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
3577: AND ac.org_id = p_org_id;

Line 3589: FROM ap_payment_history_all aph,

3585: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3586:
3587: SELECT accounting_event_id
3588: INTO l_count
3589: FROM ap_payment_history_all aph,
3590: ap_checks_all ac
3591: WHERE aph.check_id = ac.check_id
3592: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
3593: AND ac.org_id = p_org_id

Line 4569: l_bank_curr_code ap_payment_history_all.bank_currency_code%TYPE; ---7337949

4565:
4566: l_event_type xla_events.event_type_code%TYPE;
4567: l_pay_type ap_checks_all.payment_type_flag%TYPE;
4568: l_automatic_offsets_flag ap_system_parameters_all.automatic_offsets_flag%TYPE; ---7209263
4569: l_bank_curr_code ap_payment_history_all.bank_currency_code%TYPE; ---7337949
4570:
4571:
4572: BEGIN
4573:

Line 4844: FROM ap_payment_history_all APH

4840: ---added to pick bank_currency_code from payment clearing for bug 7337949
4841:
4842: SELECT aph.bank_currency_code
4843: INTO l_bank_curr_code
4844: FROM ap_payment_history_all APH
4845: WHERE APH.check_id = l_pay_clear_check_ids(i)
4846: AND APH.transaction_type = 'PAYMENT CLEARING'
4847: --added for bug 7614505
4848: AND NOT EXISTS( SELECT 'PAYMENT UNCLEARING EXISTS'

Line 4849: FROM ap_payment_history_all APH1

4845: WHERE APH.check_id = l_pay_clear_check_ids(i)
4846: AND APH.transaction_type = 'PAYMENT CLEARING'
4847: --added for bug 7614505
4848: AND NOT EXISTS( SELECT 'PAYMENT UNCLEARING EXISTS'
4849: FROM ap_payment_history_all APH1
4850: WHERE APH1.rev_pmt_hist_id = APH.payment_history_id
4851: AND APH1.transaction_type = 'PAYMENT UNCLEARING'
4852: AND APH1.check_id = APH.check_id);
4853:

Line 5793: ap_payment_history_all APH,

5789: WHERE AIP.check_id = APH.check_id
5790: AND ROWNUM = 1
5791: ) ledger_id
5792: FROM
5793: ap_payment_history_all APH,
5794: ap_checks_all AC
5795: WHERE
5796: APH.check_id = AC.check_id
5797: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469

Line 5832: ap_payment_history_all APH,

5828: WHERE AIP.check_id = APH.check_id
5829: AND ROWNUM = 1
5830: ) ledger_id
5831: FROM
5832: ap_payment_history_all APH,
5833: ap_checks_all AC
5834: WHERE
5835: APH.check_id = AC.check_id
5836: AND APH.accounting_date BETWEEN p_from_date AND p_to_date

Line 6242: FROM ap_payment_history_all APH,

6238: FROM ap_invoice_payments_all AIP
6239: WHERE AIP.check_id = APH.check_id
6240: AND ROWNUM = 1
6241: ) ledger_id
6242: FROM ap_payment_history_all APH,
6243: ap_checks_all AC
6244: WHERE APH.check_id = AC.check_id
6245: AND APH.org_id = AC.org_id
6246: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469

Line 6261: FROM ap_payment_history_all APH,

6257: FROM ap_invoice_payments_all AIP
6258: WHERE AIP.check_id = APH.check_id
6259: AND ROWNUM = 1
6260: ) ledger_id
6261: FROM ap_payment_history_all APH,
6262: ap_checks_all AC
6263: WHERE APH.check_id = AC.check_id
6264: AND APH.org_id = AC.org_id
6265: AND APH.accounting_date BETWEEN p_from_date AND p_to_date