APPS.IGF_SL_AWARD dependencies on IGF_SL_CLCHSN_DTLS

Line 1571: FROM igf_sl_clchsn_dtls chg

1567:
1568: CURSOR c_chk_fund_st_chg_2 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,
1569: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE) IS
1570: SELECT chg.disbursement_number
1571: FROM igf_sl_clchsn_dtls chg
1572: ,igf_sl_loans_all loans
1573: ,igf_aw_award_all awd
1574: WHERE chg.disbursement_number = cp_n_disb_num
1575: AND chg.change_record_type_txt = '10'