APPS.PO_NOTIFICATION_CTRL_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_notification_ctrl_draft PNCD
                  WHERE  PNCD.draft_id = p_draft_id_tbl(i)
                  AND    PNCD.notification_id = NVL(p_notification_id_tbl(i),
                                                    PNCD.notification_id)
                  AND    NVL(PNCD.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;