APPS.IBY_CE_BATCH_RECON_PKG dependencies on AP_PAYMENT_HISTORY

Line 567: ap_payment_history apha

563: 200 app_id
564: FROM iby_payments_all pmt,
565: iby_pay_service_requests ppr,
566: ap_checks_all chk,
567: ap_payment_history apha
568: WHERE pmt.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
569: AND pmt.payment_service_request_id = ppr.payment_service_request_id
570: AND ppr.calling_app_id = 200
571: AND apha.check_id = chk.check_id

Line 578: FROM ap_payment_history aphb

574: ('CLEARED', 'CLEARED BUT UNACCOUNTED',
575: 'RECONCILED', 'RECONCILED UNACCOUNTED')
576: AND NOT EXISTS
577: (SELECT aphb.payment_history_id
578: FROM ap_payment_history aphb
579: WHERE aphb.check_id = apha.check_id
580: AND aphb.rev_pmt_hist_id = apha.payment_history_id);
581:
582: l_trx_id NUMBER;