118: CC.CASHFLOW_STATUS_CODE,
119: CC.CASHFLOW_AMOUNT,
120: 260 app_id
121: FROM CE_SECURITY_PROFILES_GT le,
122: iby_fd_docs_payable_v docs,
123: iby_fd_payments_v pay,
124: CE_CASHFLOWS CC,
125: CE_CASHFLOW_ACCT_H CCH
126: WHERE pay.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
159: UNION ALL
160: SELECT count(CC.CASHFLOW_ID), sum(CC.CASHFLOW_AMOUNT) ,
161: max(CC.CASHFLOW_AMOUNT)
162: FROM CE_SECURITY_PROFILES_GT le,
163: iby_fd_docs_payable_v docs,
164: iby_fd_payments_v pay,
165: CE_CASHFLOWS CC,
166: CE_CASHFLOW_ACCT_H CCH
167: WHERE pay.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID