APPS.IGF_AW_FISAP_PKG dependencies on IGF_AW_FISAP_RANGES

Line 864: IGF_AW_FISAP_RANGES fs,

860: fs.end_range_amt,
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

Line 888: IGF_AW_FISAP_RANGES fs,

884: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
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

Line 944: IGF_AW_FISAP_RANGES FS,

940: 0, 0, 1
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

Line 978: IGF_AW_FISAP_RANGES fs,

974: 0, 0, 1
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