APPS.IGF_DB_CL_ROSTER dependencies on IGF_SL_LOAD_FILE_T

Line 209: FROM igf_sl_load_file_t

205: LTRIM(RTRIM(SUBSTR(record_data, 109, 4))) source_non_ed_brc_id,
206: LTRIM(RTRIM(SUBSTR(record_data, 114, 32))) recipient_name,
207: LTRIM(RTRIM(SUBSTR(record_data, 146, 8))) recipient_id,
208: LTRIM(RTRIM(SUBSTR(record_data, 156, 4))) recip_non_ed_brc_id
209: FROM igf_sl_load_file_t
210: WHERE lort_id = 1 AND record_data LIKE '@H%' AND file_type =
211: 'CL_ROSTER';
212:
213: CURSOR c_trailer

Line 225: FROM igf_sl_load_file_t

221: TO_NUMBER(TRIM(SUBSTR(record_data, 105, 14)))/100 tot_cancel_amt,
222: TO_NUMBER(TRIM(SUBSTR(record_data, 119, 14)))/100 tot_deficit_amt,
223: TO_NUMBER(TRIM(SUBSTR(record_data, 142, 14)))/100 tot_net_cancel_amt,
224: TO_NUMBER(TRIM(SUBSTR(record_data, 156, 14)))/100 tot_net_out_cancel_amt
225: FROM igf_sl_load_file_t
226: WHERE lort_id = (SELECT MAX(lort_id)
227: FROM igf_sl_load_file_t)
228: AND record_data LIKE '@T%' AND file_type = 'CL_ROSTER';
229:

Line 227: FROM igf_sl_load_file_t)

223: TO_NUMBER(TRIM(SUBSTR(record_data, 142, 14)))/100 tot_net_cancel_amt,
224: TO_NUMBER(TRIM(SUBSTR(record_data, 156, 14)))/100 tot_net_out_cancel_amt
225: FROM igf_sl_load_file_t
226: WHERE lort_id = (SELECT MAX(lort_id)
227: FROM igf_sl_load_file_t)
228: AND record_data LIKE '@T%' AND file_type = 'CL_ROSTER';
229:
230: CURSOR c_get_header_parameters
231: IS

Line 246: FROM igf_sl_load_file_t

242:
243: CURSOR c_dbcl
244: IS
245: SELECT record_data
246: FROM igf_sl_load_file_t
247: WHERE lort_id BETWEEN 2 AND (l_last_lort_id - 1)
248: AND file_type = 'CL_ROSTER';
249:
250: