DBA Data[Home] [Help]

APPS.OKL_BTCH_CASH_APPLIC dependencies on OKL_TRX_CSH_RECEIPT_B

Line 739: FROM okl_trx_csh_receipt_b rct

735: --declare local cursors here
736: --cursor for existing receipts in the batch,
737: CURSOR get_rct_id(cp_btc_id IN NUMBER, cp_receipt_id IN NUMBER) IS
738: SELECT rct.id
739: FROM okl_trx_csh_receipt_b rct
740: WHERE rct.btc_id = cp_btc_id
741: AND rct.id = cp_receipt_id;
742:
743: --cursor for existing receipt applications

Line 1018: FROM okl_trx_csh_receipt_b rct

1014:
1015: -- get the rct_id's ready for deletion.
1016: CURSOR get_rct_id(cp_btc_id IN NUMBER) IS
1017: SELECT rct.id
1018: FROM okl_trx_csh_receipt_b rct
1019: WHERE rct.btc_id = cp_btc_id;
1020:
1021: get_rct_id_rec get_rct_id%ROWTYPE;
1022: