APPS.IGS_PE_DUP_PERSON SQL Statements

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

Line: 33

l_Select_Clause VARCHAR2(4000);

Line: 46

  SELECT match.match_set_id
  FROM igs_pe_match_sets_all match,igs_pe_src_types src
  WHERE src.system_source_type = cp_system_source_type AND
        src.source_type_id = match.source_type_id AND
        match.match_set_id = cp_match_set_id AND
        match.closed_ind = cp_closed_ind;

Line: 55

  SELECT partial_if_null,exclude_inactive_ind
  FROM igs_pe_match_sets
  WHERE match_set_id = cp_match_set_id;

Line: 63

  SELECT data_element, drop_if_null, partial_include, exact_include
  FROM igs_pe_mtch_set_data_all
  WHERE match_set_id = cp_match_set_id;

Line: 127

        x_select_clause => l_Select_Clause
          );

Line: 133

  IF l_Select_Clause IS NOT NULL AND l_Select_Clause <> 'PARTIAL_MATCH' THEN
    BEGIN
      l_ext_cursor := DBMS_SQL.OPEN_CURSOR;

Line: 138

      DBMS_SQL.PARSE (l_ext_cursor, l_Select_Clause, DBMS_SQL.V7);

Line: 201

        x_select_clause => l_Select_Clause
        );

Line: 205

    IF l_Select_Clause IS NOT NULL THEN
      BEGIN
        l_Ext_Cursor := DBMS_SQL.OPEN_CURSOR;

Line: 210

        DBMS_SQL.PARSE (l_Ext_Cursor, l_Select_Clause, DBMS_SQL.V7);