APPS.IGF_SL_DL_CHG_ACK dependencies on IGF_LOOKUPS_VIEW

Line 35: g_dl_version igf_lookups_view.lookup_code%TYPE;

31: ***************************************************************/
32:
33:
34: g_lor_loc_rec igf_sl_lor_loc%ROWTYPE;
35: g_dl_version igf_lookups_view.lookup_code%TYPE;
36:
37: FILE_NOT_LOADED exception;
38: FILE_ALREADY_LOADED exception;
39: NOT_PHASE_IN_PARTICIPANT exception ;

Line 136: CURSOR c_get_award_year( p_dl_version igf_lookups_view.lookup_code%TYPE )

132: AND batch_type = l_batch_type;
133:
134:
135: -- Get the details of award year
136: CURSOR c_get_award_year( p_dl_version igf_lookups_view.lookup_code%TYPE )
137: IS
138: SELECT ci_cal_type, ci_sequence_number
139: FROM igf_sl_dl_setup
140: WHERE dl_version = p_dl_version ;

Line 345: l_loan_chg_status igf_lookups_view.lookup_code%TYPE;

341: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
342: l_batch_type igf_sl_dl_batch.batch_type%TYPE;
343: l_rec_present VARCHAR2(10);
344: l_stat VARCHAR2(30);
345: l_loan_chg_status igf_lookups_view.lookup_code%TYPE;
346: l_sub_col_heading VARCHAR2(1000) DEFAULT NULL;
347:
348: CURSOR cur_batch IS
349: SELECT igf_sl_dl_batch.* FROM igf_sl_dl_batch