APPS.IBY_CE_BATCH_RECON_PKG dependencies on AP_PAYMENT_HISTORY

Line 574: ap_payment_history apha

570: 200 app_id
571: FROM iby_payments_all pmt,
572: iby_pay_service_requests ppr,
573: ap_checks_all chk,
574: ap_payment_history apha
575: WHERE pmt.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
576: AND pmt.payment_service_request_id = ppr.payment_service_request_id
577: AND ppr.calling_app_id = 200
578: AND apha.check_id = chk.check_id

Line 585: FROM ap_payment_history aphb

581: ('CLEARED', 'CLEARED BUT UNACCOUNTED',
582: 'RECONCILED', 'RECONCILED UNACCOUNTED')
583: AND NOT EXISTS
584: (SELECT aphb.payment_history_id
585: FROM ap_payment_history aphb
586: WHERE aphb.check_id = apha.check_id
587: AND aphb.rev_pmt_hist_id = apha.payment_history_id);
588:
589: l_trx_id NUMBER;