APPS.IGF_SL_DL_CHG_ORIG dependencies on IGF_AW_AWARD

Line 122: lv_orig_award_id igf_aw_award.award_id%TYPE;

118: SKIP_LOAN EXCEPTION;
119: yr_full_participant EXCEPTION;
120:
121: lv_data_record VARCHAR2(4000); -- ## Variable to store the concatenated value to be stored in file ##
122: lv_orig_award_id igf_aw_award.award_id%TYPE;
123: p_tot_rec_count NUMBER := 0; -- ## Variable to store the number of records to be placed in Trailer Record ##
124: lc_chg_flag VARCHAR2(1); -- ## Flag to Indicate if any changes are there between Oldvalues and New values ##
125: lc_disb_chg_flag VARCHAR2(1); -- ## Flag to Indicate if any changes are there between Oldvalues and New ones in Disbursement tables##
126: lc_header_flag VARCHAR2(1) := 'N'; -- ## Flag to indicate if any changes had happened in loans or disbursement so as to set the header record ##

Line 190: igf_aw_award awd,

186: awd.accepted_amt
187: FROM
188: igf_sl_loans loans,
189: igf_sl_lor lor,
190: igf_aw_award awd,
191: igf_aw_fund_mast fmast,
192: igf_aw_fund_cat fcat,
193: igf_ap_fa_base_rec fabase
194: WHERE

Line 235: CURSOR cur_award(p_award_id igf_aw_award.award_id%TYPE) IS

231: AND fabase.base_id = l_base_id;
232:
233: -- ## Cursor to Retrieve the disburesment records
234:
235: CURSOR cur_award(p_award_id igf_aw_award.award_id%TYPE) IS
236: SELECT disb.* FROM igf_aw_awd_disb disb
237: WHERE disb.award_id = p_award_id
238: ORDER BY disb.disb_num;
239:

Line 244: CURSOR cur_disb_loc(p_award_id igf_aw_award.award_id%TYPE) IS

240:
241: -- ## Cursor to Retrieve the Originated disbursement records for the particular award ID
242: -- ## to compare with the disbursement table to know if any change exists
243:
244: CURSOR cur_disb_loc(p_award_id igf_aw_award.award_id%TYPE) IS
245: SELECT disb.row_id row_id, disb.disb_num, disb.disb_gross_amt, disb.disb_date
246: FROM igf_sl_awd_disb_loc disb
247: WHERE award_id = p_award_id
248: ORDER BY disb.disb_num FOR UPDATE OF disb.disb_gross_amt NOWAIT;