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_CHG_FILE dependencies on IGF_AW_AWARD

Line 36: award_id igf_aw_award_all.award_id%TYPE,

32: fund_id igf_aw_fund_mast_all.fund_id%TYPE,
33: discontinue_fund igf_aw_fund_mast_all.discontinue_fund%TYPE,
34: fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
35: base_id igf_ap_fa_base_rec_all.base_id%TYPE,
36: award_id igf_aw_award_all.award_id%TYPE,
37: loan_id igf_sl_loans_all.loan_id%TYPE,
38: loan_number igf_sl_loans_all.loan_number%TYPE,
39: loan_status igf_sl_loans_all.loan_status%TYPE,
40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,

Line 200: ,igf_aw_award_all awd

196: ) IS
197: SELECT DISTINCT lor.relationship_cd
198: FROM igf_sl_lor_all lor
199: ,igf_sl_loans_all loans
200: ,igf_aw_award_all awd
201: ,igf_aw_fund_mast_all fmast
202: ,igf_sl_cl_recipient recip
203: WHERE loans.loan_id = lor.loan_id
204: AND loans.loan_chg_status = cp_c_loan_chg_status

Line 832: CURSOR c_nof_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

828: --
829: --Change History:
830: --Who When What
831: ------------------------------------------------------------------
832: CURSOR c_nof_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
833: SELECT COUNT(awd.disb_num) tot_disb
834: FROM igf_aw_awd_disb_all awd
835: WHERE awd.award_id = cp_n_award_id
836: GROUP BY awd.award_id

Line 1040: ,igf_aw_award_all awd

1036: ,fcat.fed_fund_code
1037: ,clset.cl_version
1038: FROM igf_sl_lor_all lor
1039: ,igf_sl_loans loans
1040: ,igf_aw_award_all awd
1041: ,igf_aw_fund_mast_all fmast
1042: ,igf_aw_fund_cat_all fcat
1043: ,igf_sl_cl_setup_all clset
1044: WHERE ((lor.loan_id = cp_n_loan_id) OR cp_n_loan_id IS NULL)

Line 1530: ,igf_aw_award_all awd

1526: ,fabase.person_id student_id
1527: ,TRUNC(fabase.coa_f) coa_f
1528: FROM igf_sl_lor_all lor
1529: ,igf_sl_loans_all loans
1530: ,igf_aw_award_all awd
1531: ,igf_aw_fund_mast_all fmast
1532: ,igf_aw_fund_cat_all fcat
1533: ,igf_sl_cl_recipient recip
1534: ,igf_ap_fa_base_rec_all fabase

Line 1597: CURSOR c_aw_awd_disb (cp_n_award_id IN igf_aw_award_all.award_id%TYPE) IS

1593: WHERE chdt.loan_number_txt = cp_v_loan_number
1594: AND chdt.status_code ='R'
1595: ORDER BY change_record_type_txt,disbursement_number;
1596:
1597: CURSOR c_aw_awd_disb (cp_n_award_id IN igf_aw_award_all.award_id%TYPE) IS
1598: SELECT adisb.disb_date
1599: ,NVL(adisb.disb_accepted_amt,0) disb_accepted_amt
1600: ,adisb.hold_rel_ind
1601: ,adisb.disb_num

Line 1606: CURSOR c_aw_awd_disb2 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,

1602: FROM igf_aw_awd_disb_all adisb
1603: WHERE adisb.award_id = cp_n_award_id
1604: ORDER BY adisb.disb_num;
1605:
1606: CURSOR c_aw_awd_disb2 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,
1607: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
1608: ) IS
1609: SELECT adisb.disb_date
1610: ,NVL(adisb.disb_accepted_amt,0) disb_accepted_amt

Line 1624: CURSOR cur_get_fin_aid(cp_n_award_id IN igf_aw_award_all.award_id%TYPE ,

1620: ORDER BY adisb.disb_num;
1621:
1622: rec_c_aw_awd_disb2 c_aw_awd_disb2%ROWTYPE;
1623:
1624: CURSOR cur_get_fin_aid(cp_n_award_id IN igf_aw_award_all.award_id%TYPE ,
1625: cp_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1626: cp_awd_status_1 IN igf_aw_award.award_status%TYPE,
1627: cp_awd_status_2 IN igf_aw_award.award_status%TYPE
1628: ) IS

Line 1626: cp_awd_status_1 IN igf_aw_award.award_status%TYPE,

1622: rec_c_aw_awd_disb2 c_aw_awd_disb2%ROWTYPE;
1623:
1624: CURSOR cur_get_fin_aid(cp_n_award_id IN igf_aw_award_all.award_id%TYPE ,
1625: cp_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1626: cp_awd_status_1 IN igf_aw_award.award_status%TYPE,
1627: cp_awd_status_2 IN igf_aw_award.award_status%TYPE
1628: ) IS
1629: SELECT TRUNC(SUM(NVL(NVL(awd.accepted_amt,awd.offered_amt),0))) etsimated_fin
1630: FROM igf_aw_award_all awd

Line 1627: cp_awd_status_2 IN igf_aw_award.award_status%TYPE

1623:
1624: CURSOR cur_get_fin_aid(cp_n_award_id IN igf_aw_award_all.award_id%TYPE ,
1625: cp_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1626: cp_awd_status_1 IN igf_aw_award.award_status%TYPE,
1627: cp_awd_status_2 IN igf_aw_award.award_status%TYPE
1628: ) IS
1629: SELECT TRUNC(SUM(NVL(NVL(awd.accepted_amt,awd.offered_amt),0))) etsimated_fin
1630: FROM igf_aw_award_all awd
1631: WHERE awd.base_id = cp_n_base_id

Line 1630: FROM igf_aw_award_all awd

1626: cp_awd_status_1 IN igf_aw_award.award_status%TYPE,
1627: cp_awd_status_2 IN igf_aw_award.award_status%TYPE
1628: ) IS
1629: SELECT TRUNC(SUM(NVL(NVL(awd.accepted_amt,awd.offered_amt),0))) etsimated_fin
1630: FROM igf_aw_award_all awd
1631: WHERE awd.base_id = cp_n_base_id
1632: AND awd.award_id <> cp_n_award_id
1633: AND (awd.award_status IN (cp_awd_status_1,cp_awd_status_2));
1634:

Line 1762: l_n_est_fin igf_aw_award_all.accepted_amt%TYPE;

1758: l_c_01_24_flg VARCHAR2(1);
1759: l_n_loan_amt_increase igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
1760: l_n_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
1761: l_n_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
1762: l_n_est_fin igf_aw_award_all.accepted_amt%TYPE;
1763: l_n_pell_efc NUMBER;
1764: l_n_efc_f NUMBER;
1765: l_n_ctr_disb NUMBER;
1766: BEGIN