APPS.IGF_SL_DL_ORIG_ACK dependencies on IGF_SL_DL_SETUP

Line 181: FROM igf_sl_dl_setup

177: -- Get the award year
178: CURSOR c_get_awd_year( p_dl_version igf_lookups_view.lookup_code%TYPE)
179: IS
180: SELECT ci_cal_type, ci_sequence_number
181: FROM igf_sl_dl_setup
182: WHERE dl_version = p_dl_version;
183:
184: awd_year_rec c_get_awd_year%ROWTYPE;
185:

Line 825: l_print_opt igf_sl_dl_setup.pnote_print_ind%TYPE;

821: (reverse chronological order - newest change first)
822: ***************************************************************/
823:
824: l_row_id VARCHAR2(25);
825: l_print_opt igf_sl_dl_setup.pnote_print_ind%TYPE;
826:
827: CURSOR c_tbh_cur IS
828: SELECT igf_sl_lor.* FROM igf_sl_lor
829: WHERE loan_id = (SELECT loan_id FROM igf_sl_loans lar

Line 855: igf_sl_dl_setup

851: IS
852: SELECT
853: pnote_print_ind
854: FROM
855: igf_sl_dl_setup
856: WHERE (ci_cal_type,ci_sequence_number) = ( SELECT fmast.ci_cal_type,
857: fmast.ci_sequence_number
858: FROM igf_sl_loans loans,
859: igf_aw_award awd,