DBA Data[Home] [Help]

APPS.FV_TREASURY_PAYMENTS_PKG dependencies on AP_PAYMENT_HISTORY_ALL

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