APPS.IGF_SL_DL_VALIDATION dependencies on IGF_AW_AWD_DISB_ALL

Line 28: SELECT COUNT(*) disb_count FROM igf_aw_awd_disb_all

24: student_dtl_rec igf_sl_gen.person_dtl_rec;
25: parent_dtl_rec igf_sl_gen.person_dtl_rec;
26:
27: CURSOR cur_disb(c_award_id igf_aw_awd_disb.award_id%TYPE) IS
28: SELECT COUNT(*) disb_count FROM igf_aw_awd_disb_all
29: WHERE award_id = c_award_id
30: AND ( nvl(disb_gross_amt,0) <= 0
31: OR nvl(fee_1 ,0) <= 0
32: OR nvl(disb_net_amt ,0) <= 0);

Line 44: FROM igf_aw_awd_disb_all disb

40:
41: -- Cursor to get number of disbursements. COD-XML build.
42: CURSOR cur_get_no_of_disbursements ( cp_award_id igf_aw_awd_disb.award_id%TYPE) IS
43: SELECT COUNT(*) disb_count
44: FROM igf_aw_awd_disb_all disb
45: WHERE disb.award_id = cp_award_id;
46:
47: CURSOR cur_special_school ( cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
48: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE) IS