eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_CL_ORIG dependencies on IGF_SL_CL_RECIPIENT

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

31: Modified the reference of payment_isir_id
32:
33: -- Who When What
34: ---------------------------------------------------------------------------------
35: -- ridas 17-Sep-2004 Bug #3691146: Query optimized by using the table igf_sl_cl_recipient
36: -- instead of the view igf_sl_cl_recipient_v
37: ---------------------------------------------------------------------------------
38: -- sjadhav 23-Jul-2004 Bug 3787350, corrected zip code format
39: ---------------------------------------------------------------------------------

Line 36: -- instead of the view igf_sl_cl_recipient_v

32:
33: -- Who When What
34: ---------------------------------------------------------------------------------
35: -- ridas 17-Sep-2004 Bug #3691146: Query optimized by using the table igf_sl_cl_recipient
36: -- instead of the view igf_sl_cl_recipient_v
37: ---------------------------------------------------------------------------------
38: -- sjadhav 23-Jul-2004 Bug 3787350, corrected zip code format
39: ---------------------------------------------------------------------------------
40: -- veramach 04-May-2004 bug 3603289

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

154: x_msg_data VARCHAR2(30);
155: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
156:
157:
158: -- Query optimized by using the table igf_sl_cl_recipient instead of the view igf_sl_cl_recipient_v (bug #3691146)
159: CURSOR cur_recip_desc( p_relationship_cd VARCHAR2)
160: IS
161: SELECT
162: rcpt.recipient_id recipient_id,

Line 167: igf_sl_cl_recipient rcpt,

163: rcpt.recipient_type recipient_type,
164: lnd.description recip_description,
165: rcpt.recip_non_ed_brc_id recip_non_ed_brc_id
166: FROM
167: igf_sl_cl_recipient rcpt,
168: igf_sl_lender lnd
169: WHERE
170: rcpt.recipient_id = lnd.lender_id AND
171: rcpt.recipient_type = 'LND' AND

Line 180: igf_sl_cl_recipient rcpt,

176: rcpt.recipient_type recipient_type,
177: guarn.description recip_description,
178: rcpt.recip_non_ed_brc_id recip_non_ed_brc_id
179: FROM
180: igf_sl_cl_recipient rcpt,
181: igf_sl_guarantor guarn
182: WHERE
183: rcpt.recipient_id = guarn.guarantor_id AND
184: rcpt.recipient_type = 'GUARN' AND

Line 193: igf_sl_cl_recipient rcpt,

189: rcpt.recipient_type recipient_type,
190: srvc.description recip_description,
191: rcpt.recip_non_ed_brc_id recip_non_ed_brc_id
192: FROM
193: igf_sl_cl_recipient rcpt,
194: igf_sl_servicer srvc
195: WHERE
196: rcpt.recipient_id = srvc.servicer_id AND
197: rcpt.recipient_type = 'SRVC' AND

Line 344: igf_sl_cl_recipient recip

340: igf_aw_award_all awd,
341: igf_aw_fund_mast_all fmast,
342: igf_aw_fund_cat_all fcat,
343: igf_ap_fa_base_rec_all fabase,
344: igf_sl_cl_recipient recip
345: WHERE fabase.ci_cal_type = p_cal_type
346: AND fabase.ci_sequence_number = p_seq_number
347: AND fabase.base_id = awd.base_id
348: AND fabase.base_id = NVL (p_base_id, fabase.base_id)

Line 430: igf_sl_cl_recipient recip

426: igf_sl_lor lor,
427: igf_aw_award awd,
428: igf_aw_fund_mast fund,
429: igf_aw_fund_cat fcat,
430: igf_sl_cl_recipient recip
431: WHERE lar.loan_id = lor.loan_id
432: AND lar.award_id = awd.award_id
433: AND awd.base_id = fabase.base_id
434: AND awd.base_id = NVL(p_base_id, awd.base_id)

Line 1256: lv_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;

1252: lv_batch_id igf_sl_cl_batch.batch_id%TYPE;
1253: lv_cbth_id igf_sl_cl_batch.cbth_id%TYPE;
1254: lv_file_ident_code igf_sl_cl_file_type.file_ident_code%TYPE;
1255: lv_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;
1256: lv_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1257: lv_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1258: lv_recip_non_ed_brc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1259: l_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
1260: l_efc igf_ap_fa_base_rec_all.efc_f%TYPE;

Line 1257: lv_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;

1253: lv_cbth_id igf_sl_cl_batch.cbth_id%TYPE;
1254: lv_file_ident_code igf_sl_cl_file_type.file_ident_code%TYPE;
1255: lv_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;
1256: lv_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1257: lv_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1258: lv_recip_non_ed_brc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1259: l_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
1260: l_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
1261: lv_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;

Line 1258: lv_recip_non_ed_brc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;

1254: lv_file_ident_code igf_sl_cl_file_type.file_ident_code%TYPE;
1255: lv_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;
1256: lv_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1257: lv_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1258: lv_recip_non_ed_brc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1259: l_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
1260: l_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
1261: lv_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
1262: lv_eft_authorization igf_sl_cl_setup.eft_authorization%TYPE;