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 105: FROM ap_checks checks, iby_payments_all pmts

101: SELECT distinct check_id,
102: status_lookup_code,
103: amount,
104: 200 app_id
105: FROM ap_checks checks, iby_payments_all pmts
106: WHERE checks.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
107: AND checks.payment_id = pmts.payment_id (+)
108: AND Nvl(pmts.logical_group_reference, 'N') = Nvl(P_LOGICAL_GROUP_REFERENCE, nvl(pmts.logical_group_reference,'N'))
109:

Line 112: exists (select 1 from iby_payments_all pay

108: AND Nvl(pmts.logical_group_reference, 'N') = Nvl(P_LOGICAL_GROUP_REFERENCE, nvl(pmts.logical_group_reference,'N'))
109:
110: /* Bug 8340931
111: and
112: exists (select 1 from iby_payments_all pay
113: where nvl(logical_group_reference,'N') = nvl(P_LOGICAL_GROUP_REFERENCE,nvl(logical_group_reference,'N'))
114: and checks.payment_instruction_id = pay.payment_instruction_id
115: and checks.payment_id = pay.payment_id)*/
116: AND checks.status_lookup_code not in

Line 153: FROM ap_checks checks, iby_payments_all pmts

149:
150:
151: CURSOR l_ins_total_cur IS
152: SELECT count(check_id), sum(amount) , max(amount)
153: FROM ap_checks checks, iby_payments_all pmts
154: WHERE checks.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
155: AND checks.payment_id = pmts.payment_id (+)
156: AND Nvl(pmts.logical_group_reference, 'N') = Nvl(P_LOGICAL_GROUP_REFERENCE, nvl(pmts.logical_group_reference,'N'))
157: /* Bug 8340931

Line 158: AND exists (select 1 from iby_payments_all pay

154: WHERE checks.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
155: AND checks.payment_id = pmts.payment_id (+)
156: AND Nvl(pmts.logical_group_reference, 'N') = Nvl(P_LOGICAL_GROUP_REFERENCE, nvl(pmts.logical_group_reference,'N'))
157: /* Bug 8340931
158: AND exists (select 1 from iby_payments_all pay
159: where nvl(logical_group_reference,'N') = nvl(P_LOGICAL_GROUP_REFERENCE,nvl(logical_group_reference,'N'))
160: and checks.payment_instruction_id = pay.payment_instruction_id
161: and checks.payment_id = pay.payment_id) */
162: AND checks.status_lookup_code NOT IN

Line 571: FROM iby_payments_all pmt,

567: -- copied from apreconb 115.44
568: CURSOR l_ins_pmt_unclr_cur IS
569: SELECT chk.check_id,
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