DBA Data[Home] [Help]

APPS.OKL_BTCH_CASH_APPLIC dependencies on OKL_TXL_RCPT_APPS_B

Line 328: FROM OKL_TXL_RCPT_APPS_B

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;

Line 746: FROM okl_txl_rcpt_apps_b rca

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;

Line 1028: FROM okl_txl_rcpt_apps_b rca

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: