DBA Data[Home] [Help]

APPS.IBY_CE_BATCH_RECON_PKG dependencies on IBY_FD_PAYMENTS_V

Line 127: iby_fd_payments_v pay,

123: CC.CASHFLOW_AMOUNT,
124: 260 app_id
125: FROM CE_SECURITY_PROFILES_GT le,
126: iby_fd_docs_payable_v docs,
127: iby_fd_payments_v pay,
128: CE_CASHFLOWS CC,
129: CE_CASHFLOW_ACCT_H CCH
130: WHERE pay.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
131: AND CC.CASHFLOW_STATUS_CODE IN ('CREATED', 'CLEARED')

Line 171: iby_fd_payments_v pay,

167: SELECT count(CC.CASHFLOW_ID), sum(CC.CASHFLOW_AMOUNT) ,
168: max(CC.CASHFLOW_AMOUNT)
169: FROM CE_SECURITY_PROFILES_GT le,
170: iby_fd_docs_payable_v docs,
171: iby_fd_payments_v pay,
172: CE_CASHFLOWS CC,
173: CE_CASHFLOW_ACCT_H CCH
174: WHERE pay.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
175: AND CC.CASHFLOW_STATUS_CODE IN ('CREATED', 'CLEARED')