APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGF_AW_AWARD

Line 123: cp_awd_date igf_aw_award.award_date%TYPE

119: -- Cursor to pick up all those awards which have not yet gone into
120: -- the NSLDS database
121:
122: CURSOR c_get_addtnl_awd(
123: cp_awd_date igf_aw_award.award_date%TYPE
124: ) IS
125: SELECT SUM (NVL (awd.offered_amt, 0)) loan_amt,
126: SUM (DECODE (
127: fcat.fed_fund_code,

Line 132: FROM igf_aw_award_all awd,

128: 'FLS', NVL (awd.offered_amt, 0),
129: 'DLS', NVL (awd.offered_amt, 0),
130: 0
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

Line 153: FROM igf_aw_award_all awd,

149: CURSOR c_get_anl_awd IS
150: SELECT SUM(NVL(awd.offered_amt,0)) loan_amt,
151: SUM(DECODE(fcat.fed_fund_code,'FLS',
152: NVL(awd.offered_amt,0),'DLS',NVL(awd.offered_amt,0),0)) subs_loan_amt
153: FROM igf_aw_award_all awd,
154: igf_aw_fund_mast_all fm,
155: igf_aw_fund_cat_all fcat
156: WHERE awd.base_id = l_base_id
157: AND awd.fund_id = fm.fund_id

Line 810: p_award_id IN igf_aw_award_all.award_id%TYPE,

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,
813: p_called_from IN VARCHAR2 DEFAULT 'NON-PACKAGING'
814: ) RETURN CHAR IS

Line 898: cp_award_id igf_aw_award_all.award_id%TYPE

894: FROM igf_aw_dp_terms_v terms
895: WHERE terms.adplans_id = cp_adplans_id;
896:
897: CURSOR c_get_min_date(
898: cp_award_id igf_aw_award_all.award_id%TYPE
899: )IS
900: SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) start_dt
901: FROM igf_aw_awd_disb_v disb,
902: igf_aw_award_all awd

Line 902: igf_aw_award_all awd

898: cp_award_id igf_aw_award_all.award_id%TYPE
899: )IS
900: SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) start_dt
901: FROM igf_aw_awd_disb_v disb,
902: igf_aw_award_all awd
903: WHERE disb.award_id = cp_award_id
904: AND disb.award_id = awd.award_id
905: ORDER BY igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number);
906:

Line 941: cp_award_id igf_aw_award_all.award_id%TYPE

937: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ASC;
938:
939: -- Gets start date of the eariest term in the award
940: CURSOR c_get_ear_term_st_date_awd(
941: cp_award_id igf_aw_award_all.award_id%TYPE
942: ) IS
943: SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ear_term_start_date
944: FROM igf_aw_awd_disb_all disb,
945: igf_aw_award_all awd

Line 945: igf_aw_award_all awd

941: cp_award_id igf_aw_award_all.award_id%TYPE
942: ) IS
943: SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ear_term_start_date
944: FROM igf_aw_awd_disb_all disb,
945: igf_aw_award_all awd
946: WHERE awd.award_id = cp_award_id
947: AND awd.award_id = disb.award_id
948: ORDER BY igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ASC;
949: