[Home] [Help]
189: CURSOR lock_222 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
190: SELECT crh.cash_receipt_history_id,
191: cr.cash_receipt_id,
192: NVL(crh.current_record_flag,'N')
193: FROM ar_cash_receipts_all cr,
194: ar_cash_receipt_history_all crh,
195: ce_statement_reconcils_all rec
196: WHERE cr.cash_receipt_id = crh.cash_receipt_id
197: AND crh.rowid = trx_rowid
223: CURSOR clear_lock_222 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
224: SELECT crh.cash_receipt_history_id,
225: cr.cash_receipt_id,
226: NVL(crh.current_record_flag,'N')
227: FROM ar_cash_receipts_all cr,
228: ar_cash_receipt_history_all crh
229: WHERE cr.cash_receipt_id = crh.cash_receipt_id
230: AND crh.rowid = trx_rowid
231: FOR UPDATE OF crh.cash_receipt_history_id,
306: CURSOR LOCK_BATCH_RECEIPTS (trx_rowid VARCHAR2) IS
307: SELECT crh.cash_receipt_history_id,
308: cr.cash_receipt_id,
309: b.batch_id batch_id
310: FROM AR_CASH_RECEIPTS_all CR,
311: AR_CASH_RECEIPT_HISTORY_all CRH,
312: AR_CASH_RECEIPT_HISTORY_all CRH2,
313: AR_BATCHES_all B
314: WHERE b.rowid = trx_rowid
2307: ce_bank_accounts ba,
2308: /* Bug 13610807: for customer account join with ext accts table */
2309: iby_ext_bank_accounts ext,
2310: ar_cash_receipt_history_all crh,
2311: ar_cash_receipts_all cr,
2312: ar_receivable_applications_all ra,
2313: ar_payment_schedules_all ps
2314: WHERE sob.set_of_books_id = sp.set_of_books_id
2315: AND nvl(rec.status_flag, 'U') = 'U'
2580: ce_statement_reconcils_all rec,
2581: ce_bank_accounts ba,
2582: ce_bank_acct_uses_ou_v aba,
2583: ar_cash_receipt_history_all crh,
2584: ar_cash_receipts_all cr,
2585: ar_receivable_applications_all ra,
2586: --ra_customers rc,
2587: HZ_CUST_ACCOUNTS CU,
2588: hz_parties hp,