APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGF_AP_BATCH_AW_MAP_ALL

Line 4465: FROM igf_ap_batch_aw_map_all

4461: AND cal.sequence_number = x_ci_sequence_number;
4462:
4463: CURSOR c_profile(cp_cal_type VARCHAR2,cp_seq_number NUMBER) IS
4464: SELECT css_academic_year
4465: FROM igf_ap_batch_aw_map_all
4466: WHERE ci_cal_type = cp_cal_type
4467: AND ci_sequence_number = cp_seq_number;
4468:
4469: -- Get ci_cal_type,ci_sequence_number from IGF_AP_BATCH_AW_MAP which maps to academic year of

Line 4486: l_profile_year igf_ap_batch_aw_map_all.css_academic_year%TYPE;

4482: lv_apm_id igf_ap_person_match.APM_ID%TYPE ;
4483: alt_code_rec cur_alt_code%ROWTYPE;
4484: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
4485: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
4486: l_profile_year igf_ap_batch_aw_map_all.css_academic_year%TYPE;
4487: l_profile c_profile%ROWTYPE;
4488: INVALID_PARAMETER EXCEPTION;
4489:
4490: BEGIN