[Home] [Help]
309: ) IS
310:
311: l_dctn_txntbl g_pub_dctn_txn_tbl%TYPE;
312:
313: CURSOR C1(c_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
314: SELECT *
315: FROM PA_DEDUCTIONS_ALL
316: WHERE deduction_req_num = c_deduction_req_num
317: AND status = 'WORKING';
311: l_dctn_txntbl g_pub_dctn_txn_tbl%TYPE;
312:
313: CURSOR C1(c_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
314: SELECT *
315: FROM PA_DEDUCTIONS_ALL
316: WHERE deduction_req_num = c_deduction_req_num
317: AND status = 'WORKING';
318:
319: