APPS.PA_DCTN_APRV_NOTIFICATION dependencies on PA_DEDUCTIONS_ALL

Line 845: l_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE;

841: ,actid IN NUMBER
842: ,funcmode IN VARCHAR2
843: ,resultout OUT NOCOPY VARCHAR2) IS
844:
845: l_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE;
846: l_dctn_rec_info PA_DEDUCTIONS.cur_dctn_hdr_info%ROWTYPE;
847:
848: CURSOR C1(c_dctn_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
849: SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;

Line 848: CURSOR C1(c_dctn_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS

844:
845: l_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE;
846: l_dctn_rec_info PA_DEDUCTIONS.cur_dctn_hdr_info%ROWTYPE;
847:
848: CURSOR C1(c_dctn_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
849: SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;
850:
851: l_msg_count NUMBER;
852: l_msg_data VARCHAR2(4000);

Line 849: SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;

845: l_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE;
846: l_dctn_rec_info PA_DEDUCTIONS.cur_dctn_hdr_info%ROWTYPE;
847:
848: CURSOR C1(c_dctn_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
849: SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;
850:
851: l_msg_count NUMBER;
852: l_msg_data VARCHAR2(4000);
853: l_return_status VARCHAR2(4000);