324: AND rownum = 1;
325: --cursor to get receipt application id
326: CURSOR c_get_receipt_appln_id(p_receipt_id IN NUMBER) IS
327: SELECT id
328: FROM OKL_TXL_RCPT_APPS_B
329: WHERE rct_id_details = p_receipt_id;
330:
331: BEGIN
332: l_msg_count := 0;
742:
743: --cursor for existing receipt applications
744: CURSOR get_rca_id(cp_rct_id IN NUMBER) IS
745: SELECT rca.id
746: FROM okl_txl_rcpt_apps_b rca
747: WHERE rca.rct_id_details = cp_rct_id;
748:
749: --local variables declaration
750: get_rct_id_rec get_rct_id%ROWTYPE;
1024:
1025: -- get the rct_id's ready for deletion.
1026: CURSOR get_rca_id(cp_rct_id IN NUMBER) IS
1027: SELECT rca.id
1028: FROM okl_txl_rcpt_apps_b rca
1029: WHERE rca.rct_id_details = cp_rct_id;
1030:
1031: get_rca_id_rec get_rca_id%ROWTYPE;
1032: