APPS.IGF_DB_DL_ORIG_ACK dependencies on IGF_SL_LOAD_FILE_T

Line 88: FROM igf_sl_load_file_t

84: RTRIM(SUBSTR(record_data, 15, 8)) message_class,
85: RTRIM(SUBSTR(record_data, 46, 16)) bth_creation_date,
86: RTRIM(SUBSTR(record_data, 60, 2)) batch_rej_code,
87: RTRIM(SUBSTR(record_data, 23, 2)) batch_type
88: FROM igf_sl_load_file_t
89: WHERE lort_id = 1
90: AND record_data LIKE 'DL HEADER%'
91: AND file_type = 'DL_DISB';
92:

Line 103: FROM igf_sl_load_file_t

99: RTRIM(SUBSTR(record_data,15,7)) number_rec,
100: RTRIM(SUBSTR(record_data,22,5)) accept_rec,
101: RTRIM(SUBSTR(record_data,27,5)) reject_rec,
102: RTRIM(SUBSTr(record_data,32,5)) pending_rec
103: FROM igf_sl_load_file_t
104: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)
105: AND record_data LIKE 'DL TRAILER%'
106: AND file_type = 'DL_DISB';
107:

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

100: RTRIM(SUBSTR(record_data,22,5)) accept_rec,
101: RTRIM(SUBSTR(record_data,27,5)) reject_rec,
102: RTRIM(SUBSTr(record_data,32,5)) pending_rec
103: FROM igf_sl_load_file_t
104: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)
105: AND record_data LIKE 'DL TRAILER%'
106: AND file_type = 'DL_DISB';
107:
108: BEGIN

Line 213: FROM igf_sl_load_file_t

209: l_rowid ROWID;
210: CURSOR cur_disb
211: IS
212: SELECT record_data
213: FROM igf_sl_load_file_t
214: WHERE lort_id between 2 AND (l_last_lort_id-1)
215: AND file_type = 'DL_DISB';
216: BEGIN
217: --Added Version 2002-2003 as per Bug 2255281 DL VERSION TO BE CHECKED FOR DL CHANGE ORIG AND DISB ORIGINATION LOAN PROGRAMS.