DBA Data[Home] [Help]

APPS.PA_DEDUCTIONS_PUB dependencies on PA_DEDUCTIONS_ALL

Line 313: CURSOR C1(c_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS

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';

Line 315: FROM PA_DEDUCTIONS_ALL

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: