APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_SL_LOAD_FILE_T

Line 166: FROM igf_sl_load_file_t

162: RTRIM(SUBSTR(record_data, 15, 8)) message_class,
163: RTRIM(SUBSTR(record_data, 46, 16)) bth_creation_date,
164: RTRIM(SUBSTR(record_data, 60, 2)) batch_rej_code,
165: RTRIM(SUBSTR(record_data, 23, 2)) batch_type
166: FROM igf_sl_load_file_t
167: WHERE lort_id = 1
168: AND record_data LIKE 'DL HEADER%'
169: AND file_type = 'DL_PNOTE_ACK';
170:

Line 179: FROM igf_sl_load_file_t

175: RTRIM(SUBSTR(record_data,15,7)) number_rec,
176: RTRIM(SUBSTR(record_data,22,5)) accept_rec,
177: RTRIM(SUBSTR(record_data,27,5)) reject_rec,
178: RTRIM(SUBSTr(record_data,32,5)) pending_rec
179: FROM igf_sl_load_file_t
180: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)
181: AND record_data LIKE 'DL TRAILER%'
182: AND file_type = 'DL_PNOTE_ACK';
183:

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

176: RTRIM(SUBSTR(record_data,22,5)) accept_rec,
177: RTRIM(SUBSTR(record_data,27,5)) reject_rec,
178: RTRIM(SUBSTr(record_data,32,5)) pending_rec
179: FROM igf_sl_load_file_t
180: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)
181: AND record_data LIKE 'DL TRAILER%'
182: AND file_type = 'DL_PNOTE_ACK';
183:
184: CURSOR award_year_cur ( cp_dl_version IGF_SL_DL_SETUP.dl_version%TYPE) IS

Line 318: FROM igf_sl_load_file_t

314:
315: CURSOR c_trans
316: IS
317: SELECT record_data
318: FROM igf_sl_load_file_t
319: WHERE lort_id between 2 AND (l_last_lort_id-1)
320: AND file_type = 'DL_PNOTE_ACK';
321:
322: BEGIN