APPS.IGF_AW_FISAP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 56

            SELECT SUM (NVL (DECODE (
                            p_sum_type,
                            'PAID', awd.paid_amt,
                            'OFFERED', awd.offered_amt,
                            'ACCEPTED', awd.accepted_amt
                         ),
                         0)) total_fseog
              FROM igf_aw_award_all awd,
                   igf_aw_fund_mast_all fmast,
                   igf_aw_fund_cat_all fcat
             WHERE fcat.fed_fund_code = 'FSEOG'
               AND fmast.ci_cal_type = cp_ci_cal_type
               AND fmast.ci_sequence_number = cp_ci_sequence_number
               AND fmast.fund_code = fcat.fund_code
               AND awd.fund_id = fmast.fund_id;

Line: 76

            SELECT SUM (NVL (DECODE (
                            p_sum_type,
                            'PAID', awd.paid_amt,
                            'OFFERED', awd.offered_amt,
                            'ACCEPTED', awd.accepted_amt
                         ),
                         0)) total_match
              FROM igf_aw_award_all awd
             WHERE awd.fund_id IN (
                      SELECT fund_id
                        FROM igf_aw_fseog_match
                       WHERE ci_cal_type = cp_ci_cal_type
                         AND ci_sequence_number = cp_ci_sequence_number);

Line: 93

          SELECT  alternate_code
          FROM    igs_ca_inst
          WHERE   cal_type = cp_ci_cal_type
          AND     sequence_number = cp_ci_sequence_number;