APPS.IGF_AP_LG_COA_IMP dependencies on IGF_AP_BATCH_AW_MAP

Line 440: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;

436: g_terminate_process BOOLEAN := FALSE ;
437: g_skip_person BOOLEAN := FALSE ;
438: g_skip_record BOOLEAN := FALSE ;
439: g_skip_item_insert BOOLEAN := FALSE ;
440: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;
441: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;
442: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
443: l_rec_processed NUMBER;
444: l_rec_imported NUMBER;

Line 441: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;

437: g_skip_person BOOLEAN := FALSE ;
438: g_skip_record BOOLEAN := FALSE ;
439: g_skip_item_insert BOOLEAN := FALSE ;
440: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;
441: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;
442: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
443: l_rec_processed NUMBER;
444: l_rec_imported NUMBER;
445: l_rec_error NUMBER;

Line 478: FROM igf_ap_batch_aw_map map

474:
475: -- cursor to get sys award year and award year status
476: CURSOR c_get_stat IS
477: SELECT award_year_status_code, sys_award_year
478: FROM igf_ap_batch_aw_map map
479: WHERE map.ci_cal_type = g_ci_cal_type
480: AND map.ci_sequence_number = g_ci_sequence_number ;
481:
482: -- cursor to get persons for import