APPS.IGF_SL_DL_ORIG_ACK dependencies on IGF_SL_LOAD_FILE_T

Line 161: FROM igf_sl_load_file_t

157: RTRIM(SUBSTR(record_data, 15, 8)) message_class,
158: RTRIM(SUBSTR(record_data, 46, 16)) bth_creation_date,
159: RTRIM(SUBSTR(record_data, 60, 2)) batch_rej_code,
160: RTRIM(SUBSTR(record_data, 23, 2)) batch_type
161: FROM igf_sl_load_file_t
162: WHERE lort_id = 1
163: AND record_data LIKE 'DL HEADER%'
164: AND file_type = 'DL_ORIG_ACK';
165:

Line 172: FROM igf_sl_load_file_t

168: RTRIM(SUBSTR(record_data,15,7)) number_rec,
169: RTRIM(SUBSTR(record_data,22,5)) accept_rec,
170: RTRIM(SUBSTR(record_data,27,5)) reject_rec,
171: RTRIM(SUBSTr(record_data,32,5)) pending_rec
172: FROM igf_sl_load_file_t
173: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)
174: AND record_data LIKE 'DL TRAILER%'
175: AND file_type = 'DL_ORIG_ACK';
176:

Line 173: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)

169: RTRIM(SUBSTR(record_data,22,5)) accept_rec,
170: RTRIM(SUBSTR(record_data,27,5)) reject_rec,
171: RTRIM(SUBSTr(record_data,32,5)) pending_rec
172: FROM igf_sl_load_file_t
173: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)
174: AND record_data LIKE 'DL TRAILER%'
175: AND file_type = 'DL_ORIG_ACK';
176:
177: -- Get the award year

Line 333: SELECT record_data FROM igf_sl_load_file_t

329: DECLARE
330: l_actual_rec NUMBER DEFAULT 0;
331: l_lor_resp_num NUMBER;
332: CURSOR c_trans IS
333: SELECT record_data FROM igf_sl_load_file_t
334: WHERE lort_id between 2 AND (l_last_lort_id-1)
335: AND file_type = 'DL_ORIG_ACK';
336:
337: BEGIN