34: );
35:
36: FUNCTION efc_i(
37: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
38: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
39: ) RETURN NUMBER;
40:
41: FUNCTION get_award_data (
42: p_person_id IN NUMBER,
110: PRAGMA RESTRICT_REFERENCES(get_corr_cust_text,WNDS,WNPS);
111:
112: FUNCTION efc_f(
113: l_base_id IN NUMBER,
114: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
115: ) RETURN NUMBER;
116:
117: FUNCTION unmetneed_f(
118: l_base_id IN NUMBER,
115: ) RETURN NUMBER;
116:
117: FUNCTION unmetneed_f(
118: l_base_id IN NUMBER,
119: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
120: ) RETURN NUMBER;
121:
122: FUNCTION unmetneed_i(
123: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
120: ) RETURN NUMBER;
121:
122: FUNCTION unmetneed_i(
123: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
124: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
125: ) RETURN NUMBER;
126:
127: FUNCTION need_f(
128: l_base_id IN NUMBER,
125: ) RETURN NUMBER;
126:
127: FUNCTION need_f(
128: l_base_id IN NUMBER,
129: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
130: ) RETURN NUMBER;
131:
132: FUNCTION need_i(
133: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
130: ) RETURN NUMBER;
131:
132: FUNCTION need_i(
133: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
134: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
135: ) RETURN NUMBER;
136:
137: FUNCTION get_base_id_for_person (
138: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,