977: --
978: CURSOR lock_C IS
979: SELECT 'lock'
980: FROM ar_cash_receipts cr,
981: ar_cash_receipt_history crh
982: WHERE cr.cash_receipt_id = crh.cash_receipt_id
983: AND crh.batch_id = p_batch_id
984: FOR UPDATE OF cr.status;
985: --
1014: --
1015: CURSOR lock_C IS
1016: SELECT 'lock'
1017: FROM ar_cash_receipts cr,
1018: ar_cash_receipt_history crh
1019: WHERE cr.cash_receipt_id = crh.cash_receipt_id
1020: AND crh.batch_id = p_batch_id
1021: FOR UPDATE OF cr.status NOWAIT;
1022: --