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_PACKNG_SUBFNS dependencies on IGF_AP_FA_BASE_REC

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 644: CURSOR c_isir_id ( x_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS

640: || cdcruz 05-feb-03 Bug# 2758804 FACR105
641: || cursor c_isir_id ref changed to pick active isisr
642: */
643:
644: CURSOR c_isir_id ( x_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
645: SELECT isir_id,
646: primary_efc,
647: NVL(auto_zero_efc,'N') auto_zero_efc
648: FROM igf_ap_isir_matched

Line 654: CURSOR c_pell_efc ( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS

650: AND active_isir = 'Y';
651:
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

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 665: CURSOR get_awd_fmly_contrib_type(cp_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

661:
662: lc_pell_efc c_pell_efc%ROWTYPE;
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:

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 670: lv_awd_fmly_contrib_type igf_ap_fa_base_rec.award_fmly_contribution_type%TYPE;

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:
672: cur_rec NUMBER;
673: rows NUMBER;
674: qry_str VARCHAR2(200);

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 807: p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,

803: END get_fed_efc;
804:
805:
806: FUNCTION get_class_stnd(
807: p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
808: p_person_id IN igf_ap_fa_base_rec.person_id%TYPE,
809: p_adplans_id IN NUMBER,
810: p_award_id IN igf_aw_award_all.award_id%TYPE,
811: p_course_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,

Line 808: p_person_id IN igf_ap_fa_base_rec.person_id%TYPE,

804:
805:
806: FUNCTION get_class_stnd(
807: p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
808: p_person_id IN igf_ap_fa_base_rec.person_id%TYPE,
809: p_adplans_id IN NUMBER,
810: p_award_id IN igf_aw_award_all.award_id%TYPE,
811: p_course_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
812: p_awd_period IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,

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 1026: CURSOR c_get_cal_det(cp_base_id igf_ap_fa_base_rec.base_id%TYPE)

1022:
1023: l_get_ant_prog_type_rec c_get_ant_prog_type%ROWTYPE;
1024:
1025: -- Get the award year Calendar details
1026: CURSOR c_get_cal_det(cp_base_id igf_ap_fa_base_rec.base_id%TYPE)
1027: IS
1028: SELECT ci_cal_type, ci_sequence_number
1029: FROM igf_ap_fa_base_rec
1030: WHERE base_id = cp_base_id;

Line 1029: FROM igf_ap_fa_base_rec

1025: -- Get the award year Calendar details
1026: CURSOR c_get_cal_det(cp_base_id igf_ap_fa_base_rec.base_id%TYPE)
1027: IS
1028: SELECT ci_cal_type, ci_sequence_number
1029: FROM igf_ap_fa_base_rec
1030: WHERE base_id = cp_base_id;
1031:
1032: l_get_cal_det_rec c_get_cal_det%ROWTYPE;
1033: l_ld_cal_type igs_ca_inst.cal_type%TYPE;

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: ------------------------------------------------------------------