DBA Data[Home] [Help]

APPS.IBY_CE_BATCH_RECON_PKG dependencies on CE_CASHFLOWS

Line 124: CE_CASHFLOWS CC,

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
127: AND CC.CASHFLOW_STATUS_CODE IN ('CREATED', 'CLEARED')
128: AND CC.CASHFLOW_ID = CCH.CASHFLOW_ID

Line 165: CE_CASHFLOWS CC,

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
168: AND CC.CASHFLOW_STATUS_CODE IN ('CREATED', 'CLEARED')
169: AND CC.CASHFLOW_ID = CCH.CASHFLOW_ID