APPS.FV_TREASURY_PAYMENTS_PKG dependencies on AP_PAYMENT_HISTORY

Line 471: ap_payment_history aph

467: fnd_global.user_id,
468: fnd_global.login_id,
469: ac.org_id
470: FROM ap_checks ac,
471: ap_payment_history aph
472: WHERE ac.check_id = l_check_tbl(l_row_num).check_id
473: AND ac.void_date IS NOT NULL
474: AND (ac.checkrun_name IS NOT NULL OR ac.payment_id IS NOT NULL)
475: AND aph.check_id = ac.check_id

Line 667: l_pay_hist_id AP_PAYMENT_HISTORY_ALL.payment_history_id%TYPE;

663: AND amount < 0
664: GROUP BY check_id, accounting_date;
665:
666: l_event_status_code VARCHAR2(1);
667: l_pay_hist_id AP_PAYMENT_HISTORY_ALL.payment_history_id%TYPE;
668: l_check_id NUMBER(15);
669: l_check_number NUMBER(15);
670: l_legal_entity_id NUMBER(15);
671: l_batch NUMBER;

Line 1085: , ap_payment_history_all aph

1081: fnd_global.login_id,
1082: ac.org_id
1083: FROM ap_checks_all ac,
1084: fv_treasury_confirmations_all fvtc
1085: , ap_payment_history_all aph
1086: WHERE ac.org_id = g_org_id
1087: AND fvtc.org_id = ac.org_id
1088: AND fvtc.payment_instruction_id = ac.payment_instruction_id
1089: AND ac.void_date IS NOT NULL