APPS.IGF_AP_CALC_IM_EFC dependencies on IGF_AP_CSS_PROFILE_ALL

Line 144: cp_cssp_id igf_ap_css_profile_all.cssp_id%TYPE

140: l_profile c_all_profiles%ROWTYPE;
141:
142: -- Get fnar record for a PROFILE
143: CURSOR c_fnar(
144: cp_cssp_id igf_ap_css_profile_all.cssp_id%TYPE
145: ) IS
146: SELECT fnar.*
147: FROM igf_ap_css_fnar fnar
148: WHERE cssp_id = cp_cssp_id;

Line 152: l_efc_duration igf_ap_css_profile_all.coa_duration_num%TYPE;

148: WHERE cssp_id = cp_cssp_id;
149:
150: l_fnar igf_ap_css_fnar%ROWTYPE;
151:
152: l_efc_duration igf_ap_css_profile_all.coa_duration_num%TYPE;
153: l_coa_duration_efc_amt igf_ap_css_profile_all.coa_duration_efc_amt%TYPE;
154:
155: -- Get sys_award_year based on cal type and sequence number
156: CURSOR c_award_year(

Line 153: l_coa_duration_efc_amt igf_ap_css_profile_all.coa_duration_efc_amt%TYPE;

149:
150: l_fnar igf_ap_css_fnar%ROWTYPE;
151:
152: l_efc_duration igf_ap_css_profile_all.coa_duration_num%TYPE;
153: l_coa_duration_efc_amt igf_ap_css_profile_all.coa_duration_efc_amt%TYPE;
154:
155: -- Get sys_award_year based on cal type and sequence number
156: CURSOR c_award_year(
157: cp_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

Line 172: l_cssp_id igf_ap_css_profile_all.cssp_id%TYPE;

168: l_error_msg fnd_new_messages.message_name%TYPE DEFAULT NULL;
169:
170: lv_cssp_rowid ROWID;
171: lv_fnar_rowid ROWID;
172: l_cssp_id igf_ap_css_profile_all.cssp_id%TYPE;
173: l_fnar_id igf_ap_css_fnar_all.fnar_id%TYPE;
174: l_fnar_cssp_id igf_ap_css_fnar_all.cssp_id%TYPE;
175: l_base_id igf_ap_css_profile_all.base_id%TYPE;
176:

Line 175: l_base_id igf_ap_css_profile_all.base_id%TYPE;

171: lv_fnar_rowid ROWID;
172: l_cssp_id igf_ap_css_profile_all.cssp_id%TYPE;
173: l_fnar_id igf_ap_css_fnar_all.fnar_id%TYPE;
174: l_fnar_cssp_id igf_ap_css_fnar_all.cssp_id%TYPE;
175: l_base_id igf_ap_css_profile_all.base_id%TYPE;
176:
177: SKIP_PROFILE_RECORD EXCEPTION;
178:
179: BEGIN