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_AP_ISIR_GEN_PKG dependencies on IGF_AP_BATCH_AW_MAP_ALL

Line 2440: FROM igf_ap_attend_map_v atm, igf_ap_batch_aw_map_all bam

2436: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
2437: cp_summ_enrl_status igf_ap_isir_matched_all.summ_enrl_status%TYPE
2438: ) IS
2439: SELECT atm.attendance_type, atm.ap_att_code
2440: FROM igf_ap_attend_map_v atm, igf_ap_batch_aw_map_all bam
2441: WHERE atm.cal_type = bam.ci_cal_type
2442: AND atm.sequence_number = bam.ci_sequence_number
2443: AND bam.batch_year = cp_batch_year
2444: AND atm.ap_att_code = cp_summ_enrl_status;

Line 2468: FROM igf_ap_housing_map hm, igf_ap_batch_aw_map_all bam

2464: cp_sixth_house_plan igf_ap_isir_matched_all.sixth_house_plan%TYPE,
2465: cp_fedral_schl_code_indicator igf_ap_isir_matched_all.fedral_schl_code_indicator%TYPE
2466: ) IS
2467: SELECT housing_stat_code, ap_house_plan_code
2468: FROM igf_ap_housing_map hm, igf_ap_batch_aw_map_all bam
2469: WHERE hm.ci_cal_type = bam.ci_cal_type
2470: AND hm.ci_sequence_number = bam.ci_sequence_number
2471: AND bam.batch_year = cp_batch_year
2472: AND hm.AP_HOUSE_PLAN_CODE = DECODE(cp_fedral_schl_code_indicator, 1, cp_first_house_plan,