APPS.IGF_AP_LG_VER_IMP dependencies on IGF_AP_BATCH_AW_MAP

Line 435: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;

431: l_prof_set VARCHAR2(1) ;
432: g_terminate_process BOOLEAN := FALSE ;
433: g_skip_person BOOLEAN := FALSE ;
434: g_skip_record BOOLEAN := FALSE ;
435: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;
436: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;
437: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
438: l_rec_processed NUMBER;
439: l_rec_imported NUMBER;

Line 436: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;

432: g_terminate_process BOOLEAN := FALSE ;
433: g_skip_person BOOLEAN := FALSE ;
434: g_skip_record BOOLEAN := FALSE ;
435: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;
436: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;
437: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
438: l_rec_processed NUMBER;
439: l_rec_imported NUMBER;
440: l_last_person_number igf_ap_li_vern_ints.person_number%TYPE ;

Line 467: FROM igf_ap_batch_aw_map map

463:
464: -- cursor to get sys award year and award year status
465: CURSOR c_get_stat IS
466: SELECT award_year_status_code, sys_award_year
467: FROM igf_ap_batch_aw_map map
468: WHERE map.ci_cal_type = g_ci_cal_type
469: AND map.ci_sequence_number = g_ci_sequence_number ;
470:
471: -- cursor to get persons for import