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_AW_AWARD_ALL

Line 340: igf_aw_award_all awd,

336: lor.b_alien_reg_num_txt, -- fa 161 - bug # 5006583
337: lor.esign_src_typ_cd
338: FROM igf_sl_loans_all loans,
339: igf_sl_lor_all lor,
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

Line 694: p_n_est_fin IN igf_aw_award_all.accepted_amt%TYPE,

690: PROCEDURE insert_lor_loc_rec (
691: p_v_school_id IN VARCHAR2,
692: p_n_coa IN igf_ap_fa_base_rec_all.coa_f%TYPE,
693: p_n_efc IN igf_ap_fa_base_rec_all.efc_f%TYPE,
694: p_n_est_fin IN igf_aw_award_all.accepted_amt%TYPE,
695: p_c_alt_borr_ind_flag IN VARCHAR2
696: ) AS
697:
698:

Line 1271: l_est_fin igf_aw_award_all.accepted_amt%TYPE;

1267: lv_cl_version VARCHAR2(30);
1268:
1269: lv_s_foreign_postal_code igf_sl_lor_loc.s_foreign_postal_code%TYPE;
1270: lv_p_foreign_postal_code igf_sl_lor_loc.p_foreign_postal_code%TYPE;
1271: l_est_fin igf_aw_award_all.accepted_amt%TYPE;
1272: l_plus_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1273: l_alt_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1274: l_tot_alt_debt igf_sl_alt_borw.fed_sls_debt%TYPE;
1275: alter_rec igf_sl_alt_borw%ROWTYPE;

Line 1272: l_plus_cert_amt igf_aw_award_all.accepted_amt%TYPE;

1268:
1269: lv_s_foreign_postal_code igf_sl_lor_loc.s_foreign_postal_code%TYPE;
1270: lv_p_foreign_postal_code igf_sl_lor_loc.p_foreign_postal_code%TYPE;
1271: l_est_fin igf_aw_award_all.accepted_amt%TYPE;
1272: l_plus_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1273: l_alt_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1274: l_tot_alt_debt igf_sl_alt_borw.fed_sls_debt%TYPE;
1275: alter_rec igf_sl_alt_borw%ROWTYPE;
1276:

Line 1273: l_alt_cert_amt igf_aw_award_all.accepted_amt%TYPE;

1269: lv_s_foreign_postal_code igf_sl_lor_loc.s_foreign_postal_code%TYPE;
1270: lv_p_foreign_postal_code igf_sl_lor_loc.p_foreign_postal_code%TYPE;
1271: l_est_fin igf_aw_award_all.accepted_amt%TYPE;
1272: l_plus_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1273: l_alt_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1274: l_tot_alt_debt igf_sl_alt_borw.fed_sls_debt%TYPE;
1275: alter_rec igf_sl_alt_borw%ROWTYPE;
1276:
1277: l_count_4 NUMBER;

Line 1422: CURSOR cur_get_disb_num (p_award_id igf_aw_award_all.award_id%TYPE)

1418:
1419: --
1420: -- Cursor to fetch number of disb recs for loan
1421: --
1422: CURSOR cur_get_disb_num (p_award_id igf_aw_award_all.award_id%TYPE)
1423: IS
1424: SELECT COUNT(disb_num)
1425: FROM igf_aw_awd_disb
1426: WHERE award_id = p_award_id;