APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_SL_CL_RECIPIENT

Line 2249: ridas 17-Sep-2004 Bug #3691153: Query optimized by using the table igf_sl_cl_recipient

2245: Known Limitations,Enhancements or Remarks
2246: Change History :
2247: Who When What
2248: bvisvana 21-Sep-2005 Bug # 4168692 - IGF_SL_CL_INV_COMB_RT_RC changed to IGF_SL_CL_INV_COMB_PT_RC
2249: ridas 17-Sep-2004 Bug #3691153: Query optimized by using the table igf_sl_cl_recipient
2250: instead of the view igf_sl_cl_recipient_v
2251:
2252: bkkumar 02-04-04 FACR116 - The lender related comparison not required when "ALT" Loan
2253: bkkumar 08-oct-2003 Bug 3104228

Line 2250: instead of the view igf_sl_cl_recipient_v

2246: Change History :
2247: Who When What
2248: bvisvana 21-Sep-2005 Bug # 4168692 - IGF_SL_CL_INV_COMB_RT_RC changed to IGF_SL_CL_INV_COMB_PT_RC
2249: ridas 17-Sep-2004 Bug #3691153: Query optimized by using the table igf_sl_cl_recipient
2250: instead of the view igf_sl_cl_recipient_v
2251:
2252: bkkumar 02-04-04 FACR116 - The lender related comparison not required when "ALT" Loan
2253: bkkumar 08-oct-2003 Bug 3104228
2254: a) Impact of adding the relationship_cd

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

2308: lv_recip_non_ed_id VARCHAR2(30);
2309: lv_guarant_id VARCHAR2(30);
2310:
2311:
2312: -- Query optimized by using the table igf_sl_cl_recipient instead of the view igf_sl_cl_recipient_v (bug #3691153)
2313: CURSOR cur_find_lender IS
2314: SELECT
2315: lender_id,
2316: lend_non_ed_brc_id,

Line 2323: igf_sl_cl_recipient

2319: recip_non_ed_brc_id,
2320: enabled,
2321: relationship_cd
2322: FROM
2323: igf_sl_cl_recipient
2324: WHERE
2325: lender_id = lv_lender_id AND
2326: guarantor_id = lv_guarant_id AND
2327: recipient_id = lv_recipient_id AND