APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_LOOKUPS_VIEW

Line 154: l_dl_version igf_lookups_view.lookup_code%TYPE;

150: l_rec_batch_type VARCHAR2(100);
151:
152: l_rowid VARCHAR2(25);
153: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
154: l_dl_version igf_lookups_view.lookup_code%TYPE;
155: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
156: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
157:
158: -- ## Cursor for Fetching Header records

Line 568: SELECT lookup_code, meaning FROM igf_lookups_view

564: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
565: resp_rec.pnote_rej_codes := translate(resp_rec.pnote_rej_codes,'0',' ');
566: DECLARE
567: CURSOR c_rej IS
568: SELECT lookup_code, meaning FROM igf_lookups_view
569: WHERE lookup_type = 'IGF_SL_PNOTE_REJ_CODES'
570: AND lookup_code IN (LTRIM(RTRIM(SUBSTR(resp_rec.pnote_rej_codes, 1,2))),
571: LTRIM(RTRIM(SUBSTR(resp_rec.pnote_rej_codes, 3,2))),
572: LTRIM(RTRIM(SUBSTR(resp_rec.pnote_rej_codes, 5,2))),