APPS.IGF_SL_DL_ORIG_ACK dependencies on IGF_LOOKUPS_VIEW

Line 151: l_dl_version igf_lookups_view.lookup_code%TYPE;

147: l_rec_batch_type VARCHAR2(100);
148:
149: l_rowid VARCHAR2(25);
150: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
151: l_dl_version igf_lookups_view.lookup_code%TYPE;
152: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
153: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
154:
155: CURSOR c_header IS

Line 178: CURSOR c_get_awd_year( p_dl_version igf_lookups_view.lookup_code%TYPE)

174: AND record_data LIKE 'DL TRAILER%'
175: AND file_type = 'DL_ORIG_ACK';
176:
177: -- Get the award year
178: CURSOR c_get_awd_year( p_dl_version igf_lookups_view.lookup_code%TYPE)
179: IS
180: SELECT ci_cal_type, ci_sequence_number
181: FROM igf_sl_dl_setup
182: WHERE dl_version = p_dl_version;

Line 612: SELECT lookup_code, meaning FROM igf_lookups_view

608: ELSE
609: -- Show any Origination Reject Codes in the Log File, if any.
610: DECLARE
611: CURSOR c_rej IS
612: SELECT lookup_code, meaning FROM igf_lookups_view
613: WHERE lookup_type = 'IGF_SL_DL_ORIG_REJ_CODES'
614: AND lookup_code IN (SUBSTR(resp_rec.orig_reject_reasons, 1,2),
615: SUBSTR(resp_rec.orig_reject_reasons, 3,2),
616: SUBSTR(resp_rec.orig_reject_reasons, 5,2),