APPS.IGF_AW_FISAP_PKG dependencies on IGF_AP_BATCH_AW_MAP_ALL

Line 865: IGF_AP_BATCH_AW_MAP_ALL awmap

861: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
862: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with
863: FROM IGF_AW_FISAP_REP fisap,
864: IGF_AW_FISAP_RANGES fs,
865: IGF_AP_BATCH_AW_MAP_ALL awmap
866: WHERE awmap.ci_cal_type = cp_cal_type
867: AND awmap.ci_sequence_number = cp_seq_number
868: AND fs.sys_awd_yr = awmap.sys_award_year
869: AND fs.part_section = '2F'

Line 889: IGF_AP_BATCH_AW_MAP_ALL awmap

885: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with,
886: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'GRAD_PROF', 1, 0)) AS grad_prof
887: FROM IGF_AW_FISAP_REP fisap,
888: IGF_AW_FISAP_RANGES fs,
889: IGF_AP_BATCH_AW_MAP_ALL awmap
890: WHERE awmap.ci_cal_type = cp_cal_type
891: AND awmap.ci_sequence_number = cp_seq_number
892: AND fs.sys_awd_yr = awmap.sys_award_year
893: AND fs.part_section = '2F'

Line 945: IGF_AP_BATCH_AW_MAP_ALL AWMAP

941: )
942: ) g
943: FROM IGF_AW_FISAP_REP FISAP,
944: IGF_AW_FISAP_RANGES FS,
945: IGF_AP_BATCH_AW_MAP_ALL AWMAP
946: WHERE awmap.ci_cal_type = cp_cal_type
947: AND awmap.ci_sequence_number = cp_seq_number
948: AND fs.sys_awd_yr = awmap.sys_award_year
949: AND fs.part_section = '6A'

Line 979: IGF_AP_BATCH_AW_MAP_ALL awmap

975: )
976: ) g
977: FROM IGF_AW_FISAP_REP fisap,
978: IGF_AW_FISAP_RANGES fs,
979: IGF_AP_BATCH_AW_MAP_ALL awmap
980: WHERE awmap.ci_cal_type = cp_cal_type
981: AND awmap.ci_sequence_number = cp_seq_number
982: AND fs.sys_awd_yr = awmap.sys_award_year
983: AND fs.part_section = '6A'