APPS.IGF_AP_VER_GRPS_PRC_PKG SQL Statements

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

Line: 41

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

Line: 47

       SELECT meaning, lookup_code
       FROM   igf_lookups_view
       WHERE  lookup_type  = cp_lkup_type
       AND    lookup_code IN ('AWARD_YEAR','PERSON_NUMBER','PERSON_ID_GROUP','ITEM_CODE',
                              'PARAMETER_PASS','ISIR_FIELD') ;

Line: 56

       SELECT description
       FROM   igf_ap_td_item_mst
       WHERE  todo_number = cp_todo_number ;

Line: 65

       SELECT lkup.meaning   meaning
         FROM igf_ap_batch_aw_map  map,
              Igf_fc_sar_cd_mst    sar ,
              igf_lookups_view     lkup
        WHERE map.ci_cal_type        = cp_ci_cal_type
          AND map.ci_sequence_number = cp_ci_sequence_number
          AND sar.sys_award_year     = map.sys_award_year
          AND sar.sar_field_name     = cp_isir_field
          AND lkup.lookup_type       = cp_lkup_type
          AND lkup.lookup_code       = sar.sar_field_name
          AND lkup.enabled_flag      = 'Y'  ;

Line: 79

       SELECT pe.person_number
       FROM   igs_pe_person_base_v pe,
              igf_ap_fa_base_rec_all fa
       WHERE  pe.person_id = fa.person_id
       AND    fa.base_id = cp_base_id;

Line: 87

    SELECT description
      FROM igs_pe_persid_group
     WHERE group_id = cp_person_id_grp;

Line: 93

       SELECT description
       FROM   igf_ap_td_item_mst_all
       WHERE  todo_number = cp_item_number;

Line: 338

     SELECT 1
     FROM   igf_ap_inst_ver_item
     WHERE  base_id      = cp_base_id
     AND    isir_map_col = cp_isir_field ;

Line: 398

    ||                                  igf_ap_inst_ver_item_pkg.insert_row
    ||  masehgal        21-May-2003     #2885882  FACR113 SAR Updates
    ||                                  Changed cursors for SAR Number updates
    ||  masehgal        22-Oct-2002     Added message to show duplicate ver item rather
    ||                                  than eding the process as an error
    ||  (reverse chronological order - newest change first)
    */

      lv_rowid             ROWID   := NULL ;

Line: 412

         SELECT sar.sar_field_number isir_map_col, lkup.meaning  meaning
           FROM igf_ap_batch_aw_map    map,
                igf_ap_fa_base_rec_all fabase,
                Igf_fc_sar_cd_mst      sar ,
                igf_lookups_view       lkup
          WHERE fabase.base_id         = p_base_id
            AND map.ci_cal_type        = fabase.ci_cal_type
            AND map.ci_sequence_number = fabase.ci_sequence_number
            AND sar.sys_award_year     = map.sys_award_year
            AND sar.sar_field_name     = lv_isir_field
            AND lkup.lookup_type       = cp_lkup_type
            AND lkup.lookup_code       = sar.sar_field_name
            AND lkup.enabled_flag      = 'Y'  ;

Line: 443

                igf_ap_inst_ver_item_pkg.insert_row
                    (
                      X_ROWID                       => lv_rowid ,
                      X_BASE_ID                     => p_base_id ,
                      X_UDF_VERN_ITEM_SEQ_NUM       => NULL ,
                      X_ITEM_VALUE                  => NULL ,
                      X_WAIVE_FLAG                  => 'N' ,
                      X_INCL_IN_TOLERANCE           => NULL ,
                      X_ISIR_MAP_COL                => l_isir_map_col ,
                      x_legacy_record_flag          => NULL ,
                      x_use_blank_flag              => NULL,
                      X_MODE                        => 'R'
                    );

Line: 505

          igf_ap_batch_ver_prc_pkg.update_fed_verif_status(p_base_id,'SELECTED');

Line: 584

      SELECT base_id
      FROM   igf_ap_fa_base_rec
      WHERE  person_id = cp_person_id
      AND    ci_cal_type = cp_ci_cal_type
      AND    ci_sequence_number = cp_ci_sequence_number ;

Line: 593

      SELECT pe.person_number, pe.full_name, fa.person_id
      FROM   igf_ap_fa_base_rec fa, igs_pe_person_base_v pe
      WHERE  fa.base_id = cp_base_id
      AND    fa.person_id = pe.person_id;

Line: 602

       SELECT meaning
       FROM  igf_lookups_view
       WHERE lookup_type = cp_lkup_type
       AND   lookup_code = cp_lkup_code ;

Line: 662

        lv_sql_cnt := 'SELECT COUNT(1) '||substr(lv_sql_stmt,instr(lv_sql_stmt,'FROM'));

Line: 730

            OPEN c_person_id_grp  FOR 'SELECT person_id,person_number,full_name
                                    FROM igs_pe_person_base_v
                  WHERE person_id in ('||lv_sql_stmt||') ' USING p_prs_grp_id;

Line: 735

            OPEN c_person_id_grp  FOR 'SELECT person_id,person_number,full_name
                                    FROM igs_pe_person_base_v
                  WHERE person_id in ('||lv_sql_stmt||')';