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_AW_PACKAGING dependencies on IGF_AW_FUND_CAT

Line 319: fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,

315: fund_id NUMBER,
316: replace_fc igf_aw_fund_mast_all.replace_fc%TYPE,
317: update_need igf_aw_fund_mast_all.update_need%TYPE,
318: entitlement igf_aw_fund_mast_all.entitlement%TYPE,
319: fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
320: fm_fc_methd igf_aw_fund_mast_all.fm_fc_methd%TYPE
321: );
322:
323:

Line 435: FROM igf_aw_fund_cat fcat,

431: ) RETURN VARCHAR2 IS
432: CURSOR cur_get_fund (p_fund_id NUMBER)
433: IS
434: SELECT fcat.fed_fund_code
435: FROM igf_aw_fund_cat fcat,
436: igf_aw_fund_mast fmast
437: WHERE fcat.fund_code = fmast.fund_code
438: AND fmast.fund_id = p_fund_id;
439:

Line 458: FROM igf_aw_fund_cat fcat,

454: CURSOR cur_get_fund_type(
455: p_fund_id NUMBER
456: ) IS
457: SELECT fcat.sys_fund_type
458: FROM igf_aw_fund_cat fcat,
459: igf_aw_fund_mast fmast
460: WHERE fcat.fund_code = fmast.fund_code
461: AND fmast.fund_id = p_fund_id;
462:

Line 512: p_fund_source IN igf_aw_fund_cat_all.fund_source%type

508:
509: FUNCTION get_prog_elig(
510: p_prog_cd IN igs_ps_ver_v.course_cd%type,
511: p_prog_ver IN igs_ps_ver_v.version_number%type,
512: p_fund_source IN igf_aw_fund_cat_all.fund_source%type
513: )
514: RETURN BOOLEAN
515: IS
516: ------------------------------------------------------------------

Line 539: cp_fund_source igf_aw_fund_cat_all.fund_source%type

535: -- Check program eligibility for actual data
536: CURSOR c_chk_prog_elig_with_ver(
537: cp_stud_program_cd igs_ps_ver_v.course_cd%type,
538: cp_stud_program_ver igs_ps_ver_v.version_number%type,
539: cp_fund_source igf_aw_fund_cat_all.fund_source%type
540: )
541: IS
542: SELECT DECODE(cp_fund_source,
543: 'STATE', UPPER(state_financial_aid),

Line 556: cp_fund_source igf_aw_fund_cat_all.fund_source%type

552:
553: -- Check program eligibility for anticipated data
554: CURSOR c_chk_prog_elig_wout_ver(
555: cp_stud_program_cd igs_ps_ver_v.course_cd%type,
556: cp_fund_source igf_aw_fund_cat_all.fund_source%type
557: )
558: IS
559: SELECT 'x' FROM dual
560: WHERE EXISTS

Line 2167: igf_aw_fund_cat_all fcat

2163: fcat.fund_source,
2164: fcat.fed_fund_code,
2165: fcat.sys_fund_type
2166: FROM igf_aw_fund_mast_all fmast,
2167: igf_aw_fund_cat_all fcat
2168: WHERE fund_id = x_fund_id
2169: AND fcat.fund_code = fmast.fund_code;
2170:
2171: l_fmast c_fmast%ROWTYPE;

Line 4577: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,

4573: END doesAwardSpanOutsideAP;
4574:
4575: FUNCTION chk_gplus_loan_limits (
4576: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
4577: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
4578: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
4579: p_aid IN NUMBER,
4580: p_std_loan_tab IN igf_aw_packng_subfns.std_loan_tab,
4581: p_msg_name OUT NOCOPY fnd_new_messages.message_name%TYPE

Line 4598: lv_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;

4594: || Who When What
4595: || (reverse chronological order - newest change first)
4596: */
4597:
4598: lv_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
4599: lv_aid NUMBER := 0;
4600: lv_msg_name fnd_new_messages.message_name%TYPE := NULL;
4601: lv_ret_status BOOLEAN := FALSE;
4602: BEGIN

Line 4883: lv_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;

4879: --
4880: --Change History:
4881: --Who When What
4882: -------------------------------------------------------------------
4883: lv_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
4884: -- Get awards from a fund
4885: CURSOR c_awds(
4886: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
4887: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

Line 5791: cp_fund_code IGF_AW_FUND_CAT_ALL.FUND_CODE%TYPE

5787: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
5788:
5789: -- Returns the fund source of the given fund
5790: CURSOR c_get_fund_source(
5791: cp_fund_code IGF_AW_FUND_CAT_ALL.FUND_CODE%TYPE
5792: )
5793: IS
5794: SELECT fund_source
5795: FROM IGF_AW_FUND_CAT_ALL

Line 5795: FROM IGF_AW_FUND_CAT_ALL

5791: cp_fund_code IGF_AW_FUND_CAT_ALL.FUND_CODE%TYPE
5792: )
5793: IS
5794: SELECT fund_source
5795: FROM IGF_AW_FUND_CAT_ALL
5796: WHERE fund_code = cp_fund_code;
5797: l_get_fund_source c_get_fund_source%ROWTYPE;
5798:
5799: -- Scans the terms (starting from the earliest) in the awarding period

Line 6644: x_fund_code igf_aw_fund_cat.fund_code%TYPE,

6640:
6641: -- Get the count of all the funds from the Temp Table for a given fund code and base_id
6642: -- Here the checking for the fund for the same TERMs occurances
6643: CURSOR cur_new_awards(
6644: x_fund_code igf_aw_fund_cat.fund_code%TYPE,
6645: x_base_id igf_aw_award_t.base_id%TYPE,
6646: x_process_id igf_aw_award_t.base_id%TYPE,
6647: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6648: ) IS

Line 6671: x_fund_code igf_aw_fund_cat.fund_code%TYPE,

6667:
6668: -- Get the count of the Active Awards of the student for a given fund
6669:
6670: CURSOR cur_prior_awards(
6671: x_fund_code igf_aw_fund_cat.fund_code%TYPE,
6672: x_base_id igf_aw_award_t.base_id%TYPE,
6673: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6674: ) IS
6675: SELECT COUNT(fmast.fund_code) ftotal

Line 7654: igf_aw_fund_cat_all fcat

7650: fcat.fed_fund_code fed_fund_code,
7651: fm.fm_fc_methd fm_fc_methd
7652: FROM igf_aw_award_all awd,
7653: igf_aw_fund_mast_all fm,
7654: igf_aw_fund_cat_all fcat
7655: WHERE base_id = cp_base_id
7656: AND awd.fund_id = fm.fund_id
7657: AND fm.fund_code = fcat.fund_code
7658: AND awd.award_status IN ('ACCEPTED','OFFERED')

Line 8362: igf_aw_fund_cat_all fcat

8358: awt.award_id,
8359: awt.offered_amt
8360: FROM igf_aw_award_t awt,
8361: igf_aw_fund_mast_all fmast,
8362: igf_aw_fund_cat_all fcat
8363: WHERE awt.fund_id = fmast.fund_id
8364: AND fmast.fund_code = fcat.fund_code
8365: AND awt.base_id = x_base_id
8366: AND awt.flag IN ('CF','AU')

Line 8385: igf_aw_fund_cat_all fcat

8381: awt1.award_id,
8382: awt1.offered_amt
8383: FROM igf_aw_fund_mast_all fmast ,
8384: igf_aw_award_t awt1,
8385: igf_aw_fund_cat_all fcat
8386: WHERE g_sf_packaging = 'T'
8387: AND fmast.fund_id = g_sf_fund
8388: AND fmast.fund_id = awt1.fund_id
8389: AND fmast.fund_code = fcat.fund_code

Line 8407: igf_aw_fund_cat fcat

8403: fcat.sys_fund_type,
8404: 'Y' emulate_fed,
8405: DECODE(fmast.fm_fc_methd,'INSTITUTIONAL','Y','N') inst_method
8406: FROM igf_aw_fund_mast_all fmast ,
8407: igf_aw_fund_cat fcat
8408: WHERE fmast.fund_id = cp_fund_id
8409: AND fcat.fund_code = fmast.fund_code;
8410:
8411: l_fmast c_fmast%ROWTYPE;

Line 8557: igf_aw_fund_cat_all ca

8553: cp_process_id igf_aw_award_t.process_id%TYPE
8554: ) IS
8555: SELECT COUNT(*) cnt, fm.fund_id
8556: FROM igf_aw_fund_mast_all fm,
8557: igf_aw_fund_cat_all ca
8558: WHERE fm.fund_code = ca.fund_code
8559: AND ca.fed_fund_code ='FSEOG'
8560: AND fm.fund_id IN ( SELECT awdt.fund_id
8561: FROM igf_aw_award_t awdt

Line 8639: igf_aw_fund_cat_all fcat

8635: NVL(awd.offered_amt,0) offered_amt ,
8636: award_date
8637: FROM igf_aw_award_all awd,
8638: igf_aw_fund_mast_all fm,
8639: igf_aw_fund_cat_all fcat
8640: WHERE awd.award_status IN ('OFFERED','ACCEPTED')
8641: AND awd.base_id = cp_base_id
8642: AND awd.fund_id = fm.fund_id
8643: AND fm.fund_code = fcat.fund_code

Line 8659: igf_aw_fund_cat_all fcat

8655: NVL(awdt.offered_amt,0),
8656: SYSDATE award_date
8657: FROM igf_aw_Award_t awdt,
8658: igf_aw_fund_mast_all fmt,
8659: igf_aw_fund_cat_all fcat
8660: WHERE awdt.base_id = cp_base_id
8661: AND awdt.process_id = cp_process_id
8662: AND awdt.fund_id = fmt.fund_id
8663: AND awdt.flag = 'AW'

Line 13320: igf_aw_fund_cat fcat

13316: fm.entitlement,
13317: fm.min_award_amt,
13318: fm.max_award_amt
13319: FROM igf_aw_fund_mast fm,
13320: igf_aw_fund_cat fcat
13321: WHERE fm.fund_id = cp_fund_id
13322: AND fm.fund_code = fcat.fund_code;
13323:
13324: -- Fetch all the student when the Target Group and Person Number is not specified who