APPS.IGF_AP_CALC_IM_EFC dependencies on IGF_AP_CSS_FNAR

Line 147: FROM igf_ap_css_fnar fnar

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;
149:
150: l_fnar igf_ap_css_fnar%ROWTYPE;
151:

Line 150: l_fnar igf_ap_css_fnar%ROWTYPE;

146: SELECT fnar.*
147: FROM igf_ap_css_fnar fnar
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:

Line 173: l_fnar_id igf_ap_css_fnar_all.fnar_id%TYPE;

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:
177: SKIP_PROFILE_RECORD EXCEPTION;

Line 174: l_fnar_cssp_id igf_ap_css_fnar_all.cssp_id%TYPE;

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:
177: SKIP_PROFILE_RECORD EXCEPTION;
178:

Line 612: igf_ap_css_fnar_pkg.update_row(

608: x_stu_most_support_from_num => l_profile.stu_most_support_from_num,
609: x_location_computer_num => l_profile.location_computer_num
610: );
611: IF l_fnar_rec_fnd THEN
612: igf_ap_css_fnar_pkg.update_row(
613: x_rowid => l_fnar.row_id,
614: x_fnar_id => l_fnar.fnar_id,
615: x_cssp_id => l_fnar.cssp_id,
616: x_r_s_email_address => l_fnar.r_s_email_address,