APPS.IGF_AW_LOCK_ASSGN_PKG SQL Statements

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

Line: 57

      SELECT fa.base_id
        FROM igf_ap_fa_base_rec_all fa
       WHERE fa.ci_cal_type        =  c_ci_cal_type
         AND fa.ci_sequence_number =  c_ci_sequence_number
       ORDER BY fa.base_id;

Line: 70

      SELECT group_cd
        FROM igs_pe_persid_group_all
       WHERE group_id = c_grp_id;

Line: 81

      SELECT party_number
        FROM hz_parties
       WHERE party_id = c_person_id;

Line: 220

            'SELECT person_id,
                    person_number
               FROM igs_pe_person_base_v
              WHERE person_id IN ('||lv_sql_stmt||') ' USING p_pid_group;

Line: 226

            'SELECT person_id,
                    person_number
               FROM igs_pe_person_base_v
              WHERE person_id IN ('||lv_sql_stmt||')';