APPS.IGS_FI_GEN_APINT SQL Statements

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

Line: 61

  SELECT rfnd_destination
  FROM   igs_fi_control;

Line: 98

    SELECT unit_cd, version_number, cal_type, ci_sequence_number, location_cd, unit_class
    FROM   igs_ps_unit_ofr_opt_all
    WHERE  uoo_id = cp_n_uoo_id;

Line: 113

    SELECT alternate_code
    FROM   igs_ca_inst
    WHERE  cal_type        = cp_v_cal_type
    AND    sequence_number = cp_n_seq_number;

Line: 171

    SELECT fs.segment_num
    FROM fnd_segment_attribute_values av,
         fnd_id_flex_segments fs
    WHERE av.application_id = 101
    AND av.id_flex_code = 'GL#'
    AND av.id_flex_num = igs_fi_gen_007.get_coa_id
    AND fs.application_id = av.application_id
    AND fs.id_flex_code = av.id_flex_code
    AND fs.id_flex_num = av.id_flex_num
    AND fs.application_column_name = av.application_column_name
    AND av.segment_attribute_type = 'GL_ACCOUNT'
    AND av.attribute_value = 'Y';