APPS.IGF_SL_CL_ORIG dependencies on IGF_AW_AWD_DISB

Line 1372: FROM igf_aw_awd_disb

1368: IS
1369: SELECT disb_date,
1370: NVL(disb_accepted_amt,0) disb_accepted_amt,
1371: hold_rel_ind, direct_to_borr_flag
1372: FROM igf_aw_awd_disb
1373: WHERE award_id = loan_rec.award_id
1374: ORDER
1375: BY disb_num;
1376:

Line 1425: FROM igf_aw_awd_disb

1421: --
1422: CURSOR cur_get_disb_num (p_award_id igf_aw_award_all.award_id%TYPE)
1423: IS
1424: SELECT COUNT(disb_num)
1425: FROM igf_aw_awd_disb
1426: WHERE award_id = p_award_id;
1427:
1428:
1429: CURSOR c_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

Line 2811: FROM igf_aw_awd_disb

2807: DECLARE
2808: lv_row_id ROWID;
2809: CURSOR c_tbh_cur IS
2810: SELECT *
2811: FROM igf_aw_awd_disb
2812: WHERE award_id = loan_rec.award_id;
2813: BEGIN
2814: FOR tbh_rec IN c_tbh_cur LOOP
2815: lv_row_id := NULL;