APPS.IGF_AP_MK_PROF_ACT_PKG dependencies on IGF_AP_CSS_FNAR

Line 138: FROM igf_ap_css_fnar

134:
135: CURSOR c_get_efc(cp_cssp_id igf_ap_css_profile.cssp_id%TYPE)
136: IS
137: SELECT fm_inst_1_federal_efc
138: FROM igf_ap_css_fnar
139: WHERE cssp_id = cp_cssp_id;
140:
141: l_get_efc c_get_efc%ROWTYPE;
142:

Line 605: -- HERE GET THE VALUE OF THE EFC FROM THE OTHER PROFILE TABLE IGF_AP_CSS_FNAR

601: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
602: l_error_flag := TRUE;
603: ELSE
604: l_debug_str := l_debug_str || ' PROFILE record exists check passed';
605: -- HERE GET THE VALUE OF THE EFC FROM THE OTHER PROFILE TABLE IGF_AP_CSS_FNAR
606: l_get_efc := NULL;
607: OPEN c_get_efc(l_get_prof_rec.cssp_id);
608: FETCH c_get_efc INTO l_get_efc;
609: CLOSE c_get_efc;