APPS.PO_PRICE_DIFF_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_price_diff_draft PPDD
                  WHERE  PPDD.draft_id = p_draft_id_tbl(i)
                  AND    PPDD.price_differential_id =
                           NVL(p_price_differential_id_tbl(i),
                               PPDD.price_differential_id)
                  AND    NVL(PPDD.change_accepted_flag, 'Y') = 'Y');

Line: 93

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