eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_GR_LI_IMPORT dependencies on IGF_AP_BATCH_AW_MAP_ALL

Line 172: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;

168: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
169: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
170: g_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
171: g_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
172: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
173: g_awd_yr_status_cd igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
174: g_debug_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
175: g_disb_pad_str VARCHAR2(10) := ' ';
176: g_tot_rec_processed NUMBER :=0 ;

Line 173: g_awd_yr_status_cd igf_ap_batch_aw_map_all.award_year_status_code%TYPE;

169: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
170: g_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
171: g_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
172: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
173: g_awd_yr_status_cd igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
174: g_debug_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
175: g_disb_pad_str VARCHAR2(10) := ' ';
176: g_tot_rec_processed NUMBER :=0 ;
177: g_tot_rec_imp_warning NUMBER :=0 ;

Line 2517: FROM igf_gr_reg_amts reg, igf_ap_batch_aw_map_all batch

2513: SELECT 'x'
2514: FROM DUAL
2515: WHERE EXISTS(
2516: SELECT 'x'
2517: FROM igf_gr_reg_amts reg, igf_ap_batch_aw_map_all batch
2518: WHERE batch.ci_cal_type = cp_ci_cal_type
2519: AND batch.ci_sequence_number = cp_ci_sequence_number
2520: AND batch.sys_award_year = reg.sys_awd_yr
2521: )

Line 2524: FROM igf_gr_alt_amts alt, igf_ap_batch_aw_map_all batch

2520: AND batch.sys_award_year = reg.sys_awd_yr
2521: )
2522: AND EXISTS(
2523: SELECT 'X'
2524: FROM igf_gr_alt_amts alt, igf_ap_batch_aw_map_all batch
2525: WHERE batch.ci_cal_type = cp_ci_cal_type
2526: AND batch.ci_sequence_number = cp_ci_sequence_number
2527: AND alt.sys_awd_yr = batch.sys_award_year
2528: )

Line 2531: FROM igf_gr_tuition_fee_codes tfee, igf_ap_batch_aw_map_all batch

2527: AND alt.sys_awd_yr = batch.sys_award_year
2528: )
2529: AND EXISTS(
2530: SELECT 'X'
2531: FROM igf_gr_tuition_fee_codes tfee, igf_ap_batch_aw_map_all batch
2532: WHERE batch.ci_cal_type = cp_ci_cal_type
2533: AND batch.ci_sequence_number = cp_ci_sequence_number
2534: AND batch.sys_award_year = tfee.sys_awd_yr
2535: )