APPS.IGF_SL_REJ_WF dependencies on IGF_SL_DL_PNOTE_RESP

Line 74: SELECT igf_sl_dl_pnote_resp.pnote_rej_codes

70: FROM igf_sl_loans_v
71: WHERE loan_id = l_loanid ;
72:
73: CURSOR c_pnote_resp IS
74: SELECT igf_sl_dl_pnote_resp.pnote_rej_codes
75: FROM igf_sl_dl_pnote_resp
76: WHERE dbth_id = l_batchid
77: AND loan_number = (SELECT loan_number
78: FROM igf_sl_loans

Line 75: FROM igf_sl_dl_pnote_resp

71: WHERE loan_id = l_loanid ;
72:
73: CURSOR c_pnote_resp IS
74: SELECT igf_sl_dl_pnote_resp.pnote_rej_codes
75: FROM igf_sl_dl_pnote_resp
76: WHERE dbth_id = l_batchid
77: AND loan_number = (SELECT loan_number
78: FROM igf_sl_loans
79: WHERE loan_id = l_loanid);