APPS.IGF_AW_GEN_003 dependencies on IGF_AW_DB_CHG_DTLS

Line 4117: FROM igf_aw_db_chg_dtls

4113: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
4114: ) IS
4115: SELECT ROWID row_id,
4116: disb_status
4117: FROM igf_aw_db_chg_dtls
4118: WHERE award_id = cp_award_id
4119: AND disb_num = cp_disb_num;
4120:
4121: lv_message fnd_new_messages.message_text%TYPE;

Line 4185: igf_aw_db_chg_dtls_pkg.delete_row(get_chg_dtls.row_id);

4181:
4182: IF get_fund_rec.fed_fund_code IN ('DLS','DLP','DLU') THEN
4183: FOR get_chg_dtls IN cur_chg_dtls(p_award_id,get_adisb_rec.disb_num) LOOP
4184: IF get_chg_dtls.disb_status IN ('G') THEN
4185: igf_aw_db_chg_dtls_pkg.delete_row(get_chg_dtls.row_id);
4186: ELSE
4187: fnd_message.set_name('IGF','IGF_DB_DISB_DBCHG_FK');
4188: lv_message := fnd_message.get;
4189: RETURN lv_message;