APPS.IGF_SL_LAR_CREATION dependencies on IGF_SL_DL_SETUP_ALL

Line 131: dl_setup_rec igf_sl_dl_setup_all%ROWTYPE;

127:
128: -- FA 134
129:
130: award_rec igf_aw_award_v%ROWTYPE;
131: dl_setup_rec igf_sl_dl_setup_all%ROWTYPE;
132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;
133: p_incr_date_code VARCHAR2(100);
134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;

Line 1271: lv_orig_fee_perct igf_sl_dl_setup_all.orig_fee_perct_stafford%TYPE;

1267:
1268: lv_row_id ROWID;
1269: ln_origination_id igf_sl_lor_all.origination_id%TYPE;
1270: ld_sch_cert_date DATE;
1271: lv_orig_fee_perct igf_sl_dl_setup_all.orig_fee_perct_stafford%TYPE;
1272: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1273: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
1274: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1275: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;

Line 3181: FROM igf_sl_dl_setup_all

3177:
3178: -- for Fetching school Code for the Award Year
3179: CURSOR cur_dl_setup IS
3180: SELECT *
3181: FROM igf_sl_dl_setup_all
3182: WHERE ci_cal_type = p_ci_cal_type
3183: AND ci_sequence_number = p_ci_sequence_number;
3184:
3185: CURSOR cur_cl_setup IS