APPS.PO_ATTR_VALUES_TLP_DRAFT_PVT SQL Statements

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

Line: 74

    INSERT INTO po_session_gt
    ( key,
      num1
    )
    SELECT l_key,
           l_index_tbl(i)
    FROM DUAL
    WHERE EXISTS (SELECT 1
                  FROM   po_attribute_values_tlp_draft PAVTD
                  WHERE  PAVTD.draft_id = p_draft_id_tbl(i)
                  AND    PAVTD.attribute_values_tlp_id =
                           NVL(p_attribute_values_tlp_id_tbl(i),
                               PAVTD.attribute_values_tlp_id)
                  AND    NVL(PAVTD.change_accepted_flag, 'Y') = 'Y');

Line: 94

  DELETE FROM po_session_gt
  WHERE key = l_key
  RETURNING num1
  BULK COLLECT INTO l_dft_exists_index_tbl;