APPS.IGF_DB_CL_ROSTER dependencies on IGF_AW_AWARD_ALL

Line 1064: CURSOR c_clset (p_award_id igf_aw_award_all.award_id%TYPE)

1060: FOR UPDATE OF disb.fund_status NOWAIT;
1061:
1062: disb_rec cur_awdisb%ROWTYPE;
1063:
1064: CURSOR c_clset (p_award_id igf_aw_award_all.award_id%TYPE)
1065: IS
1066: SELECT clset.auto_late_disb_ind
1067: FROM igf_sl_cl_setup_all clset
1068: WHERE (ci_cal_type,ci_sequence_number,relationship_cd )

Line 1072: FROM igf_ap_fa_base_rec_all base, igf_aw_award_all awd,

1068: WHERE (ci_cal_type,ci_sequence_number,relationship_cd )
1069: IN
1070: (
1071: SELECT base.ci_cal_type,base.ci_sequence_number, lor.relationship_cd
1072: FROM igf_ap_fa_base_rec_all base, igf_aw_award_all awd,
1073: igf_sl_loans_all loans,igf_sl_lor_all lor
1074: WHERE base.base_id = awd.base_id
1075: AND awd.award_id = loans.award_id
1076: AND loans.loan_id = lor.loan_id