APPS.GL_TAX_CODES_PKG SQL Statements

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

Line: 22

  PROCEDURE select_row(recinfo IN OUT NOCOPY gl_tax_codes_v%ROWTYPE) IS
  BEGIN
    SELECT *
    INTO recinfo
    FROM gl_tax_codes_v
    WHERE tax_code_id = recinfo.tax_code_id
    AND   tax_type_code in
       (decode(recinfo.tax_type_code,'I', 'I', 'O', 'O'), 'T');

Line: 30

  END SELECT_ROW;

Line: 37

  PROCEDURE select_columns(
			x_tax_code_id				NUMBER,
			x_tax_type_code				VARCHAR2,
			x_tax_code			IN OUT NOCOPY	VARCHAR2) IS

    recinfo gl_tax_codes_v%ROWTYPE;

Line: 48

    select_row(recinfo);

Line: 51

  END select_columns;