DBA Data[Home] [Help]

APPS.IGF_AW_GEN_004 dependencies on IGF_AW_AWD_PRD_TERM

Line 38: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL

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,

Line 114: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL

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,

Line 119: 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,
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,

Line 124: 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,
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,

Line 129: 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,
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,

Line 134: 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,
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,