APPS.IGF_SL_CL_VALIDATION dependencies on IGF_SL_CL_RECIPIENT

Line 210: ridas 17-SEP-04 Bug #3691137: Query optimized by using the table igf_sl_cl_recipient

206: The variable 'ln_disb_amt_count' was used in the place of
207: 'ln_disb_ind_count'. Corrected this.
208: smadathi 29-oct-2004 Bug 3416936. Added new business logic as part of
209: CL4 changes
210: ridas 17-SEP-04 Bug #3691137: Query optimized by using the table igf_sl_cl_recipient
211: instead of the view igf_sl_cl_recipient_v
212:
213: bkkumar 10-apr-04 FACR116 - Added the validation for ALT_LOAN_CODE
214: mesriniv 8-jun-2002 Commented Check for P_SIGNATURE_CODE for CL_STAFFORD

Line 211: instead of the view igf_sl_cl_recipient_v

207: 'ln_disb_ind_count'. Corrected this.
208: smadathi 29-oct-2004 Bug 3416936. Added new business logic as part of
209: CL4 changes
210: ridas 17-SEP-04 Bug #3691137: Query optimized by using the table igf_sl_cl_recipient
211: instead of the view igf_sl_cl_recipient_v
212:
213: bkkumar 10-apr-04 FACR116 - Added the validation for ALT_LOAN_CODE
214: mesriniv 8-jun-2002 Commented Check for P_SIGNATURE_CODE for CL_STAFFORD
215: Commented Check for LOAN_SEQ_NUMBER for all types of Loans

Line 262: -- Query optimized by using the table igf_sl_cl_recipient instead of the view igf_sl_cl_recipient_v (bug #3691137)

258: p_status_3 igf_sl_loans.loan_status%TYPE;
259: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
260: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;
261:
262: -- Query optimized by using the table igf_sl_cl_recipient instead of the view igf_sl_cl_recipient_v (bug #3691137)
263:
264: -- masehgal # 2593215 there was a call to begin/end date fetching functions of SL11B.
265: -- However, these are not getting used anywhere .. therefore removing them ...
266:

Line 338: igf_sl_cl_recipient recip

334: igf_aw_award awd,
335: igf_aw_fund_mast fmast,
336: igf_aw_fund_cat fcat,
337: igf_ap_fa_base_rec fabase,
338: igf_sl_cl_recipient recip
339: WHERE fabase.ci_cal_type = p_cal_type
340: AND fabase.ci_sequence_number = p_seq_number
341: AND fabase.base_id = awd.base_id
342: AND fabase.base_id = NVL(p_base_id, fabase.base_id)