APPS.IGF_DB_DL_RECONC dependencies on IGF_SL_LOANS_V

Line 340: igf_sl_load_file_t , igf_sl_loans_v sl

336:
337:
338: CURSOR c_ytd_detail (cp_c_last_lort_id igf_sl_load_file_t.lort_id%TYPE) IS
339: SELECT record_data FROM
340: igf_sl_load_file_t , igf_sl_loans_v sl
341: WHERE lort_id BETWEEN 2 AND (cp_c_last_lort_id-1)
342: AND file_type ='DL_YTDD'
343: AND SUBSTR(record_data,1,1)='D'
344: AND SUBSTR(record_data,25,6)=p_school_code -- To select only those records who have a school code passed as parameter

Line 345: AND SUBSTR(record_data,51,21)=sl.loan_number--who have a valid loan number in the system(igf_sl_loans_v)

341: WHERE lort_id BETWEEN 2 AND (cp_c_last_lort_id-1)
342: AND file_type ='DL_YTDD'
343: AND SUBSTR(record_data,1,1)='D'
344: AND SUBSTR(record_data,25,6)=p_school_code -- To select only those records who have a school code passed as parameter
345: AND SUBSTR(record_data,51,21)=sl.loan_number--who have a valid loan number in the system(igf_sl_loans_v)
346: ORDER BY lort_id ;
347:
348: l_dl_ytds_rec_det igf_db_ytd_dtl%ROWTYPE;
349: l_rowid VARCHAR2(30);