APPS.IGF_SL_DL_CHG_ACK dependencies on IGF_SL_LOAD_FILE_T

Line 105: FROM igf_sl_load_file_t

101: substr(record_data, 15, 8) message_class,
102: substr(record_data, 46, 16) bth_creation_date,
103: substr(record_data, 60, 2) batch_rej_code,
104: substr(record_data, 23, 2) batch_type
105: FROM igf_sl_load_file_t
106: WHERE lort_id = 1
107: AND record_data like 'DL HEADER%'
108: AND file_type = 'DL_CHG_ACK';
109:

Line 117: FROM igf_sl_load_file_t

113: substr(record_data,15,7) number_rec,
114: substr(record_data,22,5) accept_rec,
115: substr(record_data,27,5) reject_rec,
116: substr(record_data,32,5) pending_rec
117: FROM igf_sl_load_file_t
118: WHERE lort_id = (select max(lort_id) FROM igf_sl_load_file_t)
119: AND record_data like 'DL TRAILER%'
120: AND file_type = 'DL_CHG_ACK';
121:

Line 118: WHERE lort_id = (select max(lort_id) FROM igf_sl_load_file_t)

114: substr(record_data,22,5) accept_rec,
115: substr(record_data,27,5) reject_rec,
116: substr(record_data,32,5) pending_rec
117: FROM igf_sl_load_file_t
118: WHERE lort_id = (select max(lort_id) FROM igf_sl_load_file_t)
119: AND record_data like 'DL TRAILER%'
120: AND file_type = 'DL_CHG_ACK';
121:
122: -- Cursor to check the Batch Details, if the same Batch is loaded again.

Line 258: SELECT record_data FROM igf_sl_load_file_t

254: DECLARE
255: l_actual_rec NUMBER DEFAULT 0;
256: l_lor_resp_num NUMBER;
257: CURSOR c_trans IS
258: SELECT record_data FROM igf_sl_load_file_t
259: WHERE lort_id between 2 AND (l_last_lort_id-1)
260: AND file_type = 'DL_CHG_ACK';
261: BEGIN
262: