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.IBY_CE_BATCH_RECON_PKG dependencies on IBY_PAYMENTS_ALL

Line 108: exists (select 1 from iby_payments_all pay

104: 200 app_id
105: FROM ap_checks checks
106: WHERE payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
107: and
108: exists (select 1 from iby_payments_all pay
109: where nvl(logical_group_reference,'N') = nvl(P_LOGICAL_GROUP_REFERENCE,nvl(logical_group_reference,'N'))
110: and checks.payment_instruction_id = pay.payment_instruction_id
111: and checks.payment_id = pay.payment_id)
112: AND status_lookup_code not in

Line 151: AND exists (select 1 from iby_payments_all pay

147: CURSOR l_ins_total_cur IS
148: SELECT count(check_id), sum(amount) , max(amount)
149: FROM ap_checks checks
150: WHERE payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
151: AND exists (select 1 from iby_payments_all pay
152: where nvl(logical_group_reference,'N') = nvl(P_LOGICAL_GROUP_REFERENCE,nvl(logical_group_reference,'N'))
153: and checks.payment_instruction_id = pay.payment_instruction_id
154: and checks.payment_id = pay.payment_id)
155: AND status_lookup_code NOT IN

Line 564: FROM iby_payments_all pmt,

560: -- copied from apreconb 115.44
561: CURSOR l_ins_pmt_unclr_cur IS
562: SELECT chk.check_id,
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