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

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 427: igf_aw_award awd,

423: SELECT DISTINCT lor.relationship_cd
424: FROM igf_ap_fa_base_rec fabase,
425: igf_sl_loans lar,
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

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 1387: p_award_status_1 igf_aw_award.award_status%TYPE,

1383: WHERE base_id = loan_rec.base_id;
1384:
1385: --Fetch the Estimated Financial Aid
1386: CURSOR cur_get_fin_aid(
1387: p_award_status_1 igf_aw_award.award_status%TYPE,
1388: p_award_status_2 igf_aw_award.award_status%TYPE
1389: )
1390: IS
1391: SELECT TRUNC(SUM(NVL(NVL(accepted_amt,offered_amt),0))) etsimated_fin

Line 1388: p_award_status_2 igf_aw_award.award_status%TYPE

1384:
1385: --Fetch the Estimated Financial Aid
1386: CURSOR cur_get_fin_aid(
1387: p_award_status_1 igf_aw_award.award_status%TYPE,
1388: p_award_status_2 igf_aw_award.award_status%TYPE
1389: )
1390: IS
1391: SELECT TRUNC(SUM(NVL(NVL(accepted_amt,offered_amt),0))) etsimated_fin
1392: FROM igf_aw_award

Line 1392: FROM igf_aw_award

1388: p_award_status_2 igf_aw_award.award_status%TYPE
1389: )
1390: IS
1391: SELECT TRUNC(SUM(NVL(NVL(accepted_amt,offered_amt),0))) etsimated_fin
1392: FROM igf_aw_award
1393: WHERE base_id = loan_rec.base_id
1394: AND award_id <> loan_rec.award_id
1395: AND (award_status = p_award_status_1 OR award_status = p_award_status_2);
1396:

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;