[Home] [Help]
208: CURSOR lock_222 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
209: SELECT crh.cash_receipt_history_id,
210: cr.cash_receipt_id,
211: NVL(crh.current_record_flag,'N')
212: FROM ar_cash_receipts_all cr,
213: ar_cash_receipt_history_all crh,
214: ce_statement_reconcils_all rec
215: WHERE cr.cash_receipt_id = crh.cash_receipt_id
216: AND crh.rowid = trx_rowid
242: CURSOR clear_lock_222 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
243: SELECT crh.cash_receipt_history_id,
244: cr.cash_receipt_id,
245: NVL(crh.current_record_flag,'N')
246: FROM ar_cash_receipts_all cr,
247: ar_cash_receipt_history_all crh
248: WHERE cr.cash_receipt_id = crh.cash_receipt_id
249: AND crh.rowid = trx_rowid
250: FOR UPDATE OF crh.cash_receipt_history_id,
325: CURSOR LOCK_BATCH_RECEIPTS (trx_rowid VARCHAR2) IS
326: SELECT crh.cash_receipt_history_id,
327: cr.cash_receipt_id,
328: b.batch_id batch_id
329: FROM AR_CASH_RECEIPTS_all CR,
330: AR_CASH_RECEIPT_HISTORY_all CRH,
331: AR_CASH_RECEIPT_HISTORY_all CRH2,
332: AR_BATCHES_all B
333: WHERE b.rowid = trx_rowid
2300: ce_bank_accounts ba,
2301: ce_bank_acct_uses_ou_v aba2,
2302: ce_bank_accounts ba2,
2303: ar_cash_receipt_history_all crh,
2304: ar_cash_receipts_all cr,
2305: ar_receivable_applications_all ra,
2306: ar_payment_schedules_all ps
2307: WHERE sob.set_of_books_id = sp.set_of_books_id
2308: AND nvl(rec.status_flag, 'U') = 'U'
2586: ce_statement_reconcils_all rec,
2587: ce_bank_accounts ba,
2588: ce_bank_acct_uses_ou_v aba,
2589: ar_cash_receipt_history_all crh,
2590: ar_cash_receipts_all cr,
2591: ar_receivable_applications_all ra,
2592: --ra_customers rc,
2593: HZ_CUST_ACCOUNTS CU,
2594: hz_parties hp,