APPS.IGF_SL_DL_GEN_XML dependencies on IGF_AW_DB_CHG_DTLS

Line 141: SELECT disb.rowid row_id,disb.* FROM igf_aw_db_chg_dtls disb

137: WHERE loan.loan_id = p_loan_id;
138:
139: CURSOR cur_sys_disb (p_award_id NUMBER,p_disb_num NUMBER, p_disb_seq NUMBER)
140: IS
141: SELECT disb.rowid row_id,disb.* FROM igf_aw_db_chg_dtls disb
142: WHERE disb.award_id = p_award_id AND
143: disb.disb_num = p_disb_num AND
144: disb.disb_seq_num = p_disb_seq;
145: BEGIN

Line 191: igf_aw_db_chg_dtls_pkg.update_row(x_rowid => sys_rec.row_id,

187:
188: sys_rec.disb_status := 'S';
189: sys_rec.disb_status_date := TRUNC(SYSDATE);
190:
191: igf_aw_db_chg_dtls_pkg.update_row(x_rowid => sys_rec.row_id,
192: x_award_id => sys_rec.award_id,
193: x_disb_num => sys_rec.disb_num,
194: x_disb_seq_num => sys_rec.disb_seq_num,
195: x_disb_accepted_amt => sys_rec.disb_accepted_amt,

Line 304: FROM igf_aw_db_chg_dtls chg

300: loan_oldinfo_rec cur_loan_oldinfo%ROWTYPE;
301:
302: CURSOR cur_disb_rec (p_award_id NUMBER) IS
303: SELECT chg.*
304: FROM igf_aw_db_chg_dtls chg
305: WHERE award_id = p_award_id
306: --AND disb_status = 'G'; -- Ready to Send (commented bcz of the bug 4105689)
307: AND disb_status = 'G'; -- Ready to Send (uncommented again bcz of another bug 4390096)
308: