APPS.IGF_SL_DL_CHG_ORIG dependencies on IGF_AP_FA_BASE_REC

Line 193: igf_ap_fa_base_rec fabase

189: igf_sl_lor lor,
190: igf_aw_award awd,
191: igf_aw_fund_mast fmast,
192: igf_aw_fund_cat fcat,
193: igf_ap_fa_base_rec fabase
194: WHERE
195: fabase.ci_cal_type = p_cal_type AND
196: fabase.ci_sequence_number = p_seq_num AND
197: fabase.base_id = awd.base_id AND

Line 226: CURSOR cur_isir_depend_status(l_base_id igf_ap_fa_base_rec.base_id%TYPE)

222: -- ## Cursor to retrieve the license number,license state,citizenship status,alien reg number and
223: -- ## dependency status of the Student to be compared with that in IGF_SL_LOR_LOC to see if
224: -- ## any changes exists.
225:
226: CURSOR cur_isir_depend_status(l_base_id igf_ap_fa_base_rec.base_id%TYPE)
227: IS
228: SELECT isir.dependency_status
229: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir
230: WHERE isir.isir_id = fabase.payment_isir_id

Line 229: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir

225:
226: CURSOR cur_isir_depend_status(l_base_id igf_ap_fa_base_rec.base_id%TYPE)
227: IS
228: SELECT isir.dependency_status
229: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir
230: WHERE isir.isir_id = fabase.payment_isir_id
231: AND fabase.base_id = l_base_id;
232:
233: -- ## Cursor to Retrieve the disburesment records