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.

[Home] [Help]

APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGF_AP_FA_BASE_REC_ALL

Line 67: FROM igf_ap_fa_base_rec_all

63: lv_course_type igs_ps_ver_all.course_type%TYPE;
64:
65: CURSOR c_fabase_det IS
66: SELECT *
67: FROM igf_ap_fa_base_rec_all
68: WHERE base_id = l_base_id;
69:
70: l_fabase_det c_fabase_det%ROWTYPE;
71:

Line 135: igf_ap_fa_base_rec_all fa

131: )) subs_loan_amt
132: FROM igf_aw_award_all awd,
133: igf_aw_fund_mast fm,
134: igf_aw_fund_cat_all fcat,
135: igf_ap_fa_base_rec_all fa
136: WHERE fa.person_id IN (SELECT person_id
137: FROM igf_ap_fa_base_rec_all
138: WHERE base_id = l_base_id)
139: AND awd.base_id = fa.base_id

Line 137: FROM igf_ap_fa_base_rec_all

133: igf_aw_fund_mast fm,
134: igf_aw_fund_cat_all fcat,
135: igf_ap_fa_base_rec_all fa
136: WHERE fa.person_id IN (SELECT person_id
137: FROM igf_ap_fa_base_rec_all
138: WHERE base_id = l_base_id)
139: AND awd.base_id = fa.base_id
140: AND awd.fund_id = fm.fund_id
141: AND ( cp_awd_date IS NULL

Line 656: FROM igf_ap_fa_base_rec_all fa,

652: l_isir_id c_isir_id%ROWTYPE;
653:
654: CURSOR c_pell_efc ( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
655: SELECT DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) pell_efc
656: FROM igf_ap_fa_base_rec_all fa,
657: igf_ap_isir_matched_all isir
658: WHERE fa.base_id = isir.base_id
659: AND fa.base_id = cp_base_id
660: AND isir.active_isir = 'Y';

Line 667: FROM igf_ap_fa_base_rec_all

663:
664: -- Get the details of
665: CURSOR get_awd_fmly_contrib_type(cp_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
666: SELECT award_fmly_contribution_type
667: FROM igf_ap_fa_base_rec_all
668: WHERE base_id = cp_base_id;
669:
670: lv_awd_fmly_contrib_type igf_ap_fa_base_rec.award_fmly_contribution_type%TYPE;
671:

Line 681: cp_awd_fmly_contrib_type igf_ap_fa_base_rec_all.award_fmly_contribution_type%TYPE

677:
678: CURSOR c_efc(
679: cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
680: cp_months_num NUMBER,
681: cp_awd_fmly_contrib_type igf_ap_fa_base_rec_all.award_fmly_contribution_type%TYPE
682: ) IS
683: SELECT DECODE (
684: cp_awd_fmly_contrib_type,
685: 2, DECODE (

Line 910: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

906:
907: -- museshad (Bug# 4604393)
908: -- Get the start date of the earliest term in the (COA + DP) matching terms
909: CURSOR c_get_ear_term_st_date(
910: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
911: cp_adplans_id NUMBER
912: )
913: IS
914: SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date

Line 929: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

925: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ASC;
926:
927: -- Get the start date of the earliest term in the DP matching terms
928: CURSOR c_get_ear_term_st_date_dp(
929: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
930: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
931: ) IS
932: SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date
933: FROM igf_aw_dp_terms dp_terms,

Line 965: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

961: -- for a valid anticipated class standing. The first term that has a valid anticipated
962: -- class standing data is taken into consideration. The ROWNUM predicate is
963: -- added to avoid scanning other terms in the awarding period.
964: CURSOR c_get_ant_class_stnd(
965: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
966: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE
967: )
968: IS
969: SELECT ant_data.class_standing class_standing,

Line 976: igf_ap_fa_base_rec_all fabase

972: FROM
973: igf_aw_awd_prd_term awd_per,
974: igs_ca_inst_all cal_inst,
975: igf_ap_fa_ant_data ant_data,
976: igf_ap_fa_base_rec_all fabase
977: WHERE
978: awd_per.ld_cal_type = cal_inst.cal_type AND
979: awd_per.ld_sequence_number = cal_inst.sequence_number AND
980: ant_data.ld_cal_type = awd_per.ld_cal_type AND

Line 998: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

994: -- for a valid anticipated Prog type. The first term that has a valid anticipated
995: -- Prog type data is taken into consideration. The ROWNUM predicate is
996: -- added to avoid scanning other terms in the awarding period.
997: CURSOR c_get_ant_prog_type(
998: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
999: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE
1000: )
1001: IS
1002: SELECT ant_data.program_type prog_type,

Line 1009: igf_ap_fa_base_rec_all fabase

1005: FROM
1006: igf_aw_awd_prd_term awd_per,
1007: igs_ca_inst_all cal_inst,
1008: igf_ap_fa_ant_data ant_data,
1009: igf_ap_fa_base_rec_all fabase
1010: WHERE
1011: awd_per.ld_cal_type = cal_inst.cal_type AND
1012: awd_per.ld_sequence_number = cal_inst.sequence_number AND
1013: ant_data.ld_cal_type = awd_per.ld_cal_type AND

Line 1269: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

1265: RETURN l_class_standing;
1266: END get_class_stnd;
1267:
1268: FUNCTION is_over_award_occured(
1269: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1270: p_mthd_type VARCHAR2 ,
1271: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1272: ) RETURN BOOLEAN AS
1273: ------------------------------------------------------------------